Grade Percentage into letter grade

[Guest]

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

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[RagDyer]

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!
==============================================

 

[Guest]

Thanks alot! That worked perfect.

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!
==============================================

 

[Gord Dibben]

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