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 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
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!