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.