Help with calculated column formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2783661%22%20slang%3D%22en-US%22%3EHelp%20with%20calculated%20column%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783661%22%20slang%3D%22en-US%22%3E%3CP%3EHI!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20a%20calculated%20column%20that%20inserts%20text%20when%20another%20column's%20total%20in%20between%20a%20set%20of%20numbers.%20Can%20someone%20help%20me%20with%20the%20formula%3F%20Can't%20seem%20to%20make%20it%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalculated%20Column%20is%20%3CSTRONG%3EOverall%20Score%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20%3CSTRONG%3ETotal%3C%2FSTRONG%3E%20Column%20(another%20calculated%20column)%20is%3A%3C%2FP%3E%3CP%3EBetween%201-7.99%20insert%20Needs%20Improvement%20to%20calculated%20column%20Overall%20Score%3C%2FP%3E%3CP%3EBetween%208-9.99%20insert%20Meets%20Expectations%20to%20calculated%20column%20Overall%20Score%3C%2FP%3E%3CP%3EBetween%2010-12.99%20insert%20Strong%20to%20calculated%20column%20Overall%20Score%3C%2FP%3E%3CP%3EBetween%2013-15%20insert%20Outstanding%20to%20calculated%20column%20Overall%20Score%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20and%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2783661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%20Column%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2784393%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20calculated%20column%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784393%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(AND(Total%26gt%3B%3D1%2CTotal%26lt%3B%3D7.99)%2C%22Needs%20Improvement%22%2CIF(AND(Total%26gt%3B%3D8%2CTotal%26lt%3B%3D9.99)%2C%22Meets%20Expectations%22%2CIF(AND(Total%26gt%3B%3D10%2CTotal%26lt%3B%3D12.99)%2C%22Strong%22%2CIF(AND(Total%26gt%3B%3D13%2CTotal%26lt%3B%3D15)%2C%22Outstanding%22%2C%22%22))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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?