IF Statement between Ranges

Clayton DSouza

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 1-15 review risk in 36 months, if in between 16-29 review risk in 12 months, if in between 30-50 review risk in 6 months, and if more than 70 in 3 months.

Any help is appreciated with this formula

Terry Lewis

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!

Clayton DSouza

Thank you Terry! that worked.

Appreciate the help!

Terry Lewis

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!

Clayton DSouza

Thank you Terry! that worked.

Appreciate the help!