Giving different scores a text

[stockman]

I have a score system from 0-40 points in cell a1

So lets say I want the output in cell a2 to be text: poor, low, medium, very good, excellent:

0-10=poor
10-20=low
20-30=medium
30-35=very good
35-40=Excellent

How do I do that with a formula?

So if cell a1 get the score 32, then I want cell a2 to show "very good"

[AliGW]

Set up a lookup table in C1:D5 like this:

0 Poor
10 Low
20 Medium, etc.

In A2:

=VLOOKUP(A1,$C$1:$D$5,2,1)

[AlKey]

Try this

Please Login or Register  to view this content.

[stockman]

Try this

Please Login or Register  to view this content.

Thank you sir! that was a simple and nice formula