Excel Grade Calculator: Weighted & Letter Grade Formulas (+Free Tool)

Whether you are a teacher calculating final grades or a student tracking your GPA, Excel has all the formulas you need. This guide covers weighted grade calculations, letter grade conversion, and a pass/fail checker.

Method 1: Simple average (equal weights)

If all assignments have equal weight, use AVERAGE:

=AVERAGE(B2:B10)

Replace B2:B10 with the range that contains your percentage scores. The result is the final grade as a percentage. You can also see our AVERAGE formula generator for help.

Method 2: Weighted grade with SUMPRODUCT

When exams, homework, and participation have different weights, use SUMPRODUCT:

=SUMPRODUCT(scores_range, weights_range) / SUM(weights_range)

Example: If scores are in B2:B4 and weights are in C2:C4:

=SUMPRODUCT(B2:B4, C2:C4) / SUM(C2:C4)

This multiplies each score by its weight, sums them, and divides by the total weight. See our SUMPRODUCT formula generator to build this automatically.

Method 3: Letter grade with nested IF

Convert a percentage grade to a letter grade using nested IF:

=IF(A1>=90, "A", IF(A1>=80, "B", IF(A1>=70, "C", IF(A1>=60, "D", "F"))))

This checks from highest to lowest: A (90+), B (80-89), C (70-79), D (60-69), F (below 60). Adjust the thresholds for your grading scale. Our IF formula generator can help build nested conditions.

Method 4: Pass/Fail with IF

=IF(A1>=60, "Pass", "Fail")

Simple and effective. Replace 60 with your passing threshold. Our Pass/Fail formula generator automates this.

Pro tip: use named ranges

Select your score and weight cells, go to Formulas → Define Name, and give them names like Scores and Weights. Then your formula becomes:

=SUMPRODUCT(Scores, Weights) / SUM(Weights)

Named ranges make grade books much easier to read and audit.