Number of opened and closed parentheses do not match.... where am I going wrong?

 

Number of opened and closed parentheses do not match.... where am I going wrong?

IFS(
AND(
[Age]<49,[PSA]<2.5),
"Your PSA Levels are within the referenced range proposed by NICE which is 2.5 for those between the age of 40 and 49.",

AND(
[Age]>50,[Age] <59),
[PSA] <=3.5), "Your PSA Levels are above the referenced range proposed by NICE which is 3.5 for those between the age of 50 and 59. Please speak with your GP.",

AND(
[Age]>60,[Age]<69),[PSA]<4.5), "Your PSA Levels are within the referenced range proposed by NICE which is 4.5 for those between the age of 60 and 69.",

AND(
[Age]>70,[Age] <79),[PSA] <6.5, "Your PSA Levels are within the referenced range proposed by NICE which is 6.5 for those between the age of 70 and 79."))

 

 

0 2 91
2 REPLIES 2

.

Marc_Dillon_0-1676080140018.png

 

Thanks for you pateince Marc.

I removed those and it still doesn't seem to work. Do you have another solution I  could consider?

I also removed the symbols you highlighted on the other commands within the formula and still the same error.

 

Top Labels in this Space