Excel Magic Trick
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
Full Page With All File Links: http://people.highline.edu/mgirvin/ex...
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
