Maliki Hassani
asked on
Excel: Formula to code value ranges by category
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER