How to Calculate Letter Grade in Excel (With Examples)

Often you may want to convert a percentage grade to a letter grade in Excel.

There are two common ways to do so by using the IFS function in Excel:

Method 1: Calculate Letter Grade Using A, B, C, D, F

=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",B2<60,"F")

Method 2: Calculate Letter Grade Using A, B, C, D, F with Plus or Minus

=IFS(B2>=97,"A+",B2>=93,"A",B2>=90,"A",B2>=87,"B+",B2>=83,"B",B2>=80,"B-",B2>=77,"C+",B2>=73,"C",B2>=70,"C-",B2>=67,"D+",B2>=63,"D",B2>=60,"D-",B2<60,"F")

The following examples show how to use each method in practice with the following dataset in Excel:

Example 1: Calculate Letter Grade Using A, B, C, D, F

We can type the following formula into cell C2 to calculate the letter grade for the first student:

=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",B2<60,"F")

We can then click and drag this formula down to each remaining cell in column C:

Excel calculate letter grade

Column C uses the following logic to assign a letter grade to each student based on their score:

If the score is greater than or equal to 90, assign a letter grade of A.
Else, if the score is greater than or equal to 80, assign a letter grade of B.
Else, if the score is greater than or equal to 70, assign a letter grade of C.

And so on.

Note: Feel free to change the numeric values in the IFS function if you use different values to assign letter grades.

Example 2: Calculate Letter Grade Using A, B, C, D, F with Plus or Minus

We can type the following formula into cell C2 to calculate the letter grade with a plus or minus for the first student:

=IFS(B2>=97,"A+",B2>=93,"A",B2>=90,"A",B2>=87,"B+",B2>=83,"B",B2>=80,"B-",B2>=77,"C+",B2>=73,"C",B2>=70,"C-",B2>=67,"D+",B2>=63,"D",B2>=60,"D-",B2<60,"F")