Grade Percentage into letter grade
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%?
|