Create a low (0-182); medium (183-365) and high (365+) Age formula

System
Employee Admin
This discussion was created from comments split from: How do I create an CountIF statement to include multiple selections within a cell?.
Answers
-
Genevieve I have one more that is stumping me. I need to create a low (0-182); medium (183-365) and high (365+) Age formula and =IF(Age@row<182,"LOW"), IF(AND(Age@row>=MIN(183)),VALUE(<=MAX(365)), "MEDIUM", IF(Age@row>=MIN(366)"HIGH")))) is not working.
-
Hi Jeannette!!
The problem, it seems to me, is that you are using MIN and MAX, but they are not necessary, as you already put the limit numbers.
Try:
=IF(Age@row<182,"LOW", IF(AND(Age@row>=183, Age@row<=365), "MEDIUM", IF(Age@row>=366, "HIGH")))
and it also appears that a comma is missing before the word "HIGH".
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!