# How to Calculate Average Letter Grades in Excel – 4 Methods

A sample letter grade standard is shown in the dataset below.

### Method 1 – Use the IF and the AVERAGE Functions to Calculate Average Letter Grades

The IF function checks whether a condition is met and, returns a value if True and another if False.

The AVERAGE function returns the average (arithmetic mean) of its arguments.

Steps:

• Add two new rows to the sheet.

• Calculate the average score in C12.
• Enter the following formula.
`=AVERAGE(F6:F10)`

• Press Enter to see the result.

• Enter another formula in C13.
`=IF(C12>=90,"A",IF(C12>=80,"B",IF(C12>=70,"C",IF(C12>=60,"D","F"))))`

• Press Enter.

This is the output.

### Method 2 – Apply the IFS Function

The IFS function checks whether one or more conditions are met and, returns a value corresponding to the first TRUE condition.

Steps:

• Go to C13 and enter the formula.
`=IFS(C12>=90,"A",C12>=80,"B",C12>=70,"C",C12>=60,"D",C12<60,"F")`

• Press Enter to see the result.

This is the output.

### Method 3 – Use the VLOOKUP Function to Get the Average Letter Grades

Steps:

• Add a new column to the dataset. This column contains the lowest score of each level.

• Enter the VLOOKUP formula in C13.
`=VLOOKUP(C12,\$C\$6:\$D\$10,2,TRUE)`

• Press Enter.

### Method 4 – Combine the MATCH & INDEX Functions

The MATCH function returns the relative position of an item in an array that matches a specified value in a specified order.

The INDEX function returns a value or reference of the cell at the intersection of the particular row and column in a given range.

Steps:

• Enter the formula in C13.
`=INDEX(D6:D10,MATCH(C12,C6:C10,1))`

• Press Enter to see the result.

Formula Breakdown

• MATCH(C12,C6:C10,1)

finds a match for  C12 in C6:C10. If it finds a value less than C12 in that range, it shows the row number.

Result: 3

• INDEX(D6:D10,MATCH(C12,C6:C10,1))

shows the value of the corresponding row in D6:D10.

Result: C

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF