Forum Discussion
Solved
Calculated field based off number range in other column
Hi, I am trying to create a calculated column that will take the outcome of a different column and auto populate this field with a choice. so for example the ranges would be >=60 in the other...
christopherturner87 Did you try formula given in my answer above?
If it is not working for you, try this:
=IF([Risk Rating]<29,"Low Risk",IF(AND([Risk Rating]>30,[Risk Rating]<59),"Medium Risk",IF([Risk Rating]>60,"High Risk", "")))Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
christopherturner87 Did you try formula given in my answer above?
If it is not working for you, try this:
=IF([Risk Rating]<29,"Low Risk",IF(AND([Risk Rating]>30,[Risk Rating]<59),"Medium Risk",IF([Risk Rating]>60,"High Risk", "")))
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
The first equation worked to get me the Low & Medium but not the high but this formula did exactly what i was looking for. Thank you for your help!