Grading

N

Nirvelli

I have a grading sheet for a class that uses formulas to return a grade
percentage. I was wondering if there is any way to get a letter grade
(ex. 0%-60% in one cell will put "F" in another cell, 90%-100% in one
cell will put "A" in another cell). Any help would be great.
 
B

Bob Phillips

N irvelli,

Perfect for VLOOKUP.

Try

=VLOOKUP(A5,{0,"F";0.6,"E";0.7,"D";0.75,"C";0.8,"B";0.9,"A"},2,TRUE)

just change the limits accordingly.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

J.E. McGimpsey

A straight LOOKUP() works, too:

=LOOKUP(A5,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"})
 
P

Peo Sjoblom

One way

=IF(A1="","",VLOOKUP(A1,{0,"F";0.61,"D";0.71,"C";0.81,"B";0.9,"A"},2))

or maybe this

=IF(A1="","",VLOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2))
 
Top