In my past blog, I described an easy way of calculating grades. In the real world, professors distribute many tests and assignments through the semester.  Here is an example:

The formula in column H calculates each assignment with the weighted percentage. In H1 the formula is as follows:


The formula in column I is an IF THEN ELSE statement that calculates the grade letter for each student. In I1 the formula is as follows:


After I test these two formulas, I select both formulas and copy it down by doubling clicking on the Autofill handle on the bottom right of the I1 cell (the little black solid icon). See diagram: