Gradebook: Score = Grade

  • Thread starter Thread starter Arion
  • Start date Start date
A

Arion

I'm a teacher trying to create a customized grade book. I've managed to
average weighted grades, but now I need to know how to convert a score in a
cell to a letter grade. For example, an average of 82.5 in cell AO3 being
converted to a C- in cell AN3. Any help you could provide will be greatly
appreciated.

DKB
 
Here's a formula

=VLOOKUP(AO3,{30,"F";40,"E";50,"D";60,"C";70,"C+";80,"B";90,"B+";100,"A"},2)

since you only mention 82.5 and C- it is hard to know how your grading works
but I am
sure you can adapt the above to fit.
 
Back
Top