IF Statement between Ranges
Hello,
I am not sure what i am doing wrong in the formula
=IF([Current Risk Score]@row < 15, "36 Months", IF([Current Risk Score]@row > 70, "3 Months", IF(AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29, "12 Months", IF(AND([Current Risk Score]@row > 30, [Current Risk Score]@row < 50, "6 Months"))))))
Essentially if "Current Risk Score" is between 115 review risk in 36 months, if in between 1629 review risk in 12 months, if in between 3050 review risk in 6 months, and if more than 70 in 3 months.
Any help is appreciated with this formula
Best Answers

Hi!
You'll need to close the parenthesis on the AND statements (and remove extras from the end)
AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29)
That should work. Good luck!

Thank you Terry! that worked.
Appreciate the help!
Answers

Hi!
You'll need to close the parenthesis on the AND statements (and remove extras from the end)
AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29)
That should work. Good luck!

Thank you Terry! that worked.
Appreciate the help!
Help Article Resources
Categories
Check out the Formula Handbook template!