|
Featured Tutorial
Featured Macro
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
VLOOKUP function information.
ROUND function
Formulas for Grades.
Excel Lookup Series