Excel Forum

Excel Magic Trick #194: Grade Book Based on Percentages

Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percentage Scores that will calculate grade for you automatically. See how the VLOOKUP and the Percentage format can deliver the wrong Grade when you dont use the Round Function.
VLOOKUP function information.
ROUND function
Formulas for Grades.
Excel Lookup Series

Got a Question? Ask it Here in the Forum.