software

I have 5 ranking for evaulations: quot;Failedquot;, quot;Poorquot;, quot;Satisfactoryquot;, quot;Goodquot;,
and quot;Excellentquot;. 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 gt; 90 = Excellent.

How do I do this in Excel?

One way:

=LOOKUP(A1,{0,quot;Failedquot;; 50.1,quot;Poorquot;; 65.1,quot;Satisfactoryquot;;
75.1,quot;Goodquot;; 90.1,quot;Excellentquot;})

In article gt;,
Mike Carpenter lt;Mike gt; wrote:

gt; I have 5 ranking for evaulations: quot;Failedquot;, quot;Poorquot;, quot;Satisfactoryquot;, quot;Goodquot;,
gt; and quot;Excellentquot;. Depedning on the results of a calculation, I want to have
gt; the ranking displayed in a cell.
gt; Example:
gt; Ranking of 1-50 = Failed
gt; Ranking of 51-65 = Poor
gt; Ranking of 66-75 = Satisfactory
gt; Ranking of 76-90 = Good
gt; Ranking gt; 90 = Excellent.
gt;
gt; How do I do this in Excel?

Tried that, no matter was in cell, result was quot;Excellentquot;...

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =LOOKUP(A1,{0,quot;Failedquot;; 50.1,quot;Poorquot;; 65.1,quot;Satisfactoryquot;;
gt; 75.1,quot;Goodquot;; 90.1,quot;Excellentquot;})
gt;
gt; In article gt;,
gt; Mike Carpenter lt;Mike gt; wrote:
gt;
gt; gt; I have 5 ranking for evaulations: quot;Failedquot;, quot;Poorquot;, quot;Satisfactoryquot;, quot;Goodquot;,
gt; gt; and quot;Excellentquot;. Depedning on the results of a calculation, I want to have
gt; gt; the ranking displayed in a cell.
gt; gt; Example:
gt; gt; Ranking of 1-50 = Failed
gt; gt; Ranking of 51-65 = Poor
gt; gt; Ranking of 66-75 = Satisfactory
gt; gt; Ranking of 76-90 = Good
gt; gt; Ranking gt; 90 = Excellent.
gt; gt;
gt; gt; How do I do this in Excel?
gt;

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

Works fine here...

In article gt;,
Mike Carpenter gt; wrote:

gt; Tried that, no matter was in cell, result was quot;Excellentquot;...