Thread
:
Copy contents to cell based on value in second cell
View Single Post
#
2
Posted to microsoft.public.excel.misc
JE McGimpsey
Posts: n/a
Copy contents to cell based on value in second cell
One way:
=LOOKUP(A1,{0,"Failed"; 50.1,"Poor"; 65.1,"Satisfactory";
75.1,"Good"; 90.1,"Excellent"})
In article ,
Mike Carpenter <Mike
wrote:
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?
Reply With Quote