Excel Forum



Excel Magic Trick #195: Grade Book That Subtracts Lowest Score


Use the SUM, MIN and VLOOKUP functions to create a Grade Book Based on Total Score minus the lowest score (lowest score removed) 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.