Forum Discussion
Solved
Calculated column - IF statement
I am trying to create an calculated column which returns a piece of text based on the number in a different field - 1-4 = Manageable 5-19 = Material 20 - 39 = Severe 40+ = Very Severe The nu...
Can you try below formula:
=IF(ISBLANK([Initial Risk Score]),"",IF([Initial Risk Score]<5,"Manageable",IF(AND([Initial Risk Score]>=5,[Initial Risk Score]<=19),"Material",IF(AND([Initial Risk Score]>=20,[Initial Risk Score]<=39),"Severe",IF([Initial Risk Score]>=40,"Very Severe","")))))Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
Can you try below formula:
=IF(ISBLANK([Initial Risk Score]),"",IF([Initial Risk Score]<5,"Manageable",IF(AND([Initial Risk Score]>=5,[Initial Risk Score]<=19),"Material",IF(AND([Initial Risk Score]>=20,[Initial Risk Score]<=39),"Severe",IF([Initial Risk Score]>=40,"Very Severe","")))))
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
This works perfectly thank you