Copy contents to cell based on value in second cell

[Guest]

I have 5 ranking for evaulations: "Failed", "Poor", "Satisfactory", "Good",
and "Excellent". Depedning on the results of a calculation, I want to have
the ranking displayed in a cell.
Example:
Ranking of 1-50 = Failed
Ranking of 51-65 = Poor
Ranking of 66-75 = Satisfactory
Ranking of 76-90 = Good
Ranking > 90 = Excellent.

How do I do this in Excel?

 

[JE McGimpsey]

One way:

=LOOKUP(A1,{0,"Failed"; 50.1,"Poor"; 65.1,"Satisfactory";
75.1,"Good"; 90.1,"Excellent"})

 

[Guest]

Tried that, no matter was in cell, result was "Excellent"...

 

[JE McGimpsey]

Do you have your calculations set to automatic
(Tools/Options/Calculation)?

Works fine here...