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%?

http://www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)


"James" wrote in message
...
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%?

Try something like this:

=LOOKUP(A1,{0,60,70,80,90;"E","D","C","B","A"})

Revise the values to suit.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"James" wrote in message
...
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%?

Thanks alot! That worked perfect.

"RagDyer" wrote:

Try something like this:

=LOOKUP(A1,{0,60,70,80,90;"E","D","C","B","A"})

Revise the values to suit.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"James" wrote in message
...
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%?

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},{"E","D"," C-","C","C+","B","B+","A"})

Example only, change the number ranges to suit.


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 18:45:01 -0800, "James"
wrote:

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%?