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."))
.
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.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |