Copy contents to cell based on value in second cell

[Mike Carpenter]

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"})

In article <[email protected]>,
Mike Carpenter <Mike [email protected]> 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?

[Mike Carpenter]

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

"JE McGimpsey" wrote:

> One way:
>
> =LOOKUP(A1,{0,"Failed"; 50.1,"Poor"; 65.1,"Satisfactory";
> 75.1,"Good"; 90.1,"Excellent"})
>
> In article <[email protected]>,
> Mike Carpenter <Mike [email protected]> 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?
>

[JE McGimpsey]

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

Works fine here...

In article <[email protected]>,
Mike Carpenter <[email protected]> wrote:

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