Grading

[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.

 

[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.E. McGimpsey]

A straight LOOKUP() works, too:

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

 

[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))

 

[Don Guillett]

or. Adjust to fit your needs

=LOOKUP(J2,{0,50,60,70},{"F","D","C","B"})

 

[Nirvelli]

Thanks. It works good.