Excel:  Formula to code value ranges by category

Maliki Hassani
Maliki Hassani used Ask the Experts™
on
Experts,

I am needing assistance on how to code a formula by percentage categories.  For example:

if cell A1 is 97.00 or greater then "Expert"
if cell A1 is greater or equal to 80.00  and less than 97.00 then "Skilled"
if cell A1 is greater or equal to 50.00 and less than 80.00 then "Working"
if cell A1 is less than 50.00 then "Learning"

Thanks everyone
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
=IF(A1>97,"Expert",IF(A1>80,"Skilled",IF(A1>50,"Working","Learning")))

Author

Commented:
Excellent thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial