Help with calculated column formulas

New Contributor

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!

3 Replies

=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)

Thank you!
I copy and pasted into the formula box and there is an error. I am trying to attach a pic but it isn't working for some reason.
The "total" column is a sum formula, is that an issue?