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

AppSheet AppSheet Q&A
1

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.”))

2

.

Marc_Dillon_0-1676080140018.png
Marc_Dillon_0-1676080140018.png812×467 29 KB

2 Likes
3

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.