Sep 24 2021 02:58 PM
HI!
I am trying to do a calculated column that inserts text when another column's total in between a set of numbers. Can someone help me with the formula? Can't seem to make it work.
Calculated Column is Overall Score
If the Total Column (another calculated column) is:
Between 1-7.99 insert Needs Improvement to calculated column Overall Score
Between 8-9.99 insert Meets Expectations to calculated column Overall Score
Between 10-12.99 insert Strong to calculated column Overall Score
Between 13-15 insert Outstanding to calculated column Overall Score
Please and Thank you!
Sep 25 2021 02:31 AM
=IF(AND(Total>=1,Total<=7.99),"Needs Improvement",IF(AND(Total>=8,Total<=9.99),"Meets Expectations",IF(AND(Total>=10,Total<=12.99),"Strong",IF(AND(Total>=13,Total<=15),"Outstanding",""))))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Sep 25 2021 12:43 PM
Sep 25 2021 12:44 PM