Dears,

If I have the below rating,


Outstanding
Excellent
V.Good
Good
Need Improvement
Poor

And I rank the above rating based on the below percentages,

0 -10%
11 - 20%
21- 30%
31 - 50%
51 - 80%
81 - 100%

How can automate excel to show Outstanding in a specific cell when the rating cell is between 0-10% and so on?


Thank you very very much.