View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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?