Here are some other Excel functions I have found useful in determining grades.

Use SMALL to drop multiple grades as MIN only determines smallest.

=SMALL(cell1:cell5,1) lowest

=SMALL(cell1:cell5,2) 2nd lowest

LOOKUP can be used to determine letter grade as outlined below.

=LOOKUP(cell with grade,{0,60,65,70,73,77,80,83,87,90,93},{"F","D","D+","C-","C","C+","B-","B","B+","A-","A"})

The numbers above are whole numbers due to the slightly different way I determine the final grade.

One of my favorite Excel function is the =VLOOKUP function, that works similarly. This is intriguing, though.