software

What formula would I use to turn a class percentage into a letter grade. If
a student has a 94% for the class how do I get excel to relflect that into an
a if the range is 90-100%?

www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)quot;Jamesquot; gt; wrote in message
news
gt; What formula would I use to turn a class percentage into a letter grade.
gt; If
gt; a student has a 94% for the class how do I get excel to relflect that into
gt; an
gt; a if the range is 90-100%?Try something like this:

=LOOKUP(A1,{0,60,70,80,90;quot;Equot;,quot;Dquot;,quot;Cquot;,quot;Bquot;,quot;Aquot;})

Revise the values to suit.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Jamesquot; gt; wrote in message
news
gt; What formula would I use to turn a class percentage into a letter grade.
If
gt; a student has a 94% for the class how do I get excel to relflect that into
an
gt; a if the range is 90-100%?Thanks alot! That worked perfect.

quot;RagDyerquot; wrote:

gt; Try something like this:
gt;
gt; =LOOKUP(A1,{0,60,70,80,90;quot;Equot;,quot;Dquot;,quot;Cquot;,quot;Bquot;,quot;Aquot;})
gt;
gt; Revise the values to suit.
gt; --
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt; quot;Jamesquot; gt; wrote in message
gt; news
gt; gt; What formula would I use to turn a class percentage into a letter grade.
gt; If
gt; gt; a student has a 94% for the class how do I get excel to relflect that into
gt; an
gt; gt; a if the range is 90-100%?
gt;
gt;

James

Assuming scores are in column A starting at A1.

In B1 enter this formula then drag/copy down column B

=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{quot;Equot;,quot;Dquot;,quot; C-quot;,quot;Cquot;,quot;C quot;,quot;Bquot;,quot;B quot;,quot;Aquot;})

Example only, change the number ranges to suit.Gord Dibben Excel MVP

On Tue, 13 Dec 2005 18:45:01 -0800, quot;Jamesquot; gt;
wrote:

gt;What formula would I use to turn a class percentage into a letter grade. If
gt;a student has a 94% for the class how do I get excel to relflect that into an
gt;a if the range is 90-100%?