How to calculate letter grade in Excel?
To assign letter grade for each student based on their scores may be a common task for a teacher, for example, I have a grading scale defined where the score below 60 is an F, 60 to 70 is a D, 70 to 80 is a C, 80 to 90 is a B, and 90 to 100 is an A. In Excel, how could you calculate letter grade based on the numeric score quickly and easily?
Combine / import multiple worksheets or csv files into one worksheet or workbook:
In your daily work, to combine multiple worksheets, workbooks and csv files into one single worksheet or workbook may be a huge and headachy work. But, if you have Kutools for Excel, with its powerful utility – Combine, you can quickly combine multiple worksheets, workbooks or csv files into one worksheet or workbook.
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
The following formula can help you to quickly calculate the letter grade as you need, please do as this:
Enter this formula: =IF(E2>=90,"A",IF(E2>=80,"B",IF(E2>=70,"C",IF(E2>=60,"D","F")))) into a blank cell next to your score data where you want to locate the letter grade, F2, for instance, and then drag the fill handle down to the cells that you want to contain this formula, and the letter grade has been displayed in each cell as follows:
Note: In the above formula, E2 is the cell which you want to convert the number to letter grade, and the numbers 90, 80, 70, and 60 are the numbers you need to assign the grading scale. You can modify them as you need.
If there are more grading scales, such as following screenshot, I have defined a grade scale table, and now, I want to apply this grade scale to the score list table. In this case, the VLOOKUP function can help you.
Please enter this formula: =VLOOKUP(B2,$F$1:$G$10,2,TRUE) into a blank cell beside your data, C2, for example, and then drag the fill handle down to the cells that you want to apply this formula, and now, you can see all the letter grades based on the corresponding grade scale table are calculated at once, see screenshot:
Note: In the above formula, B2 is the cell which you want to calculate the letter grade, F1:G10 is the table range you want to look for, the number 2 indicates the lookup table column number which contains the values you want to return.