Excel Forum



Excel Magic Trick #193: Grade Book Based on Total Score


Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score that will calculate grade for you automatically.
VLOOKUP function information.
Formulas for Grades.
Excel Lookup Series





Got a Question? Ask it Here in the Forum.