To find a letter grade from a score in Excel, enter the score in a cell and use a formula such as =IF(B2="","",IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))). This example assumes a 0–100 score in B2 and a grading scale of A at 90, B at 80, C at 70, D at 60, and F below 60. Set the cutoffs to match your course before copying the formula to other students.
What You’ll Need
- Excel for Microsoft 365 on Windows. The same formulas work in current Excel for Mac and Excel for the web, although the ribbon layout can differ slightly.
- A column of numeric scores, with one student’s score in each row.
- The grading scale you want to use, including its cutoffs. Do not assume every class uses the same thresholds or plus/minus grades.
Step-by-Step
- Choose what “grade” means for your sheet. This guide uses a letter grade assigned from a numeric score. Decide whether the score is entered as points out of 100, a percentage such as 87, or a true Excel percentage such as 87%. These are not interchangeable in a formula: Excel stores 87% as 0.87. Also confirm whether a cutoff is inclusive. The examples below treat a score exactly at a cutoff as earning the higher grade.
- Set up a simple score column. In a blank worksheet, type a heading such as Score in B1 and enter the first student’s numeric score in B2. Put a heading such as Grade in C1. Continue entering scores down column B, one per row. Keep the score cells numeric; if you type labels such as “87 points” into the same cell, Excel may not evaluate them as intended.
- Enter a letter-grade formula. With a score from 0 to 100 in B2 and the example cutoffs A=90, B=80, C=70, D=60, and F below 60, enter this in C2:
=IF(B2="","",IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))). The first part leaves the grade cell empty when B2 is empty. The remaining tests run from the highest cutoff to the lowest, so an 84 returns B and a 59 returns F. Change the cutoff numbers and grade labels to match your policy. - Check the result before filling the column. Try a score at a cutoff and one just below it. For example, with the stated scale, 90 returns A and 89 returns B; 60 returns D and 59 returns F. These quick checks help confirm both the scale and the boundary behavior. If a test result is not what you expect, review the cutoff values and the order of the comparisons before copying the formula.
- Copy the formula to the other rows. Select C2, then drag the small square at the lower-right corner of the selection (the fill handle) down alongside the scores. Excel adjusts B2 to B3, B4, and so on. Alternatively, select C2 and the cells below it that should contain grades, then choose Home > Fill > Down. Leave rows without scores blank; the formula is designed to show a blank grade for a blank score.
- Use a percentage scale when Excel stores scores as percentages. If B2 contains 87% as a true percentage, its underlying value is 0.87, not 87. With a percentage score in B2 and the same letter cutoffs expressed as percentages, enter this in C2:
=IF(B2="","",IF(B2>=90%,"A",IF(B2>=80%,"B",IF(B2>=70%,"C",IF(B2>=60%,"D","F"))))). The result for 87% is B. Do not use the first formula’s cutoff of 90 against an Excel value of 0.87: that would make the score appear far below the cutoff. - Calculate a percentage from points, if needed. If B2 contains points earned and C2 contains the total possible points, enter this in D2:
=IFERROR(B2/C2,""). Format D2 as a percentage using Home > Number > Percentage. For example, 42 points earned out of 50 returns 84%, displayed as 84%. Then apply the percentage-based grade formula from the previous step to D2 instead of B2, placing that grade formula in another column such as E2. The IFERROR wrapper leaves the result blank when the total is missing or zero, rather than displaying a division error. - Consider a lookup table for a scale you may change. This is useful when several sheets use the same policy or when cutoffs change between terms. Put the minimum score for each grade in E2:E6 and the matching grade in F2:F6: 0 and F, 60 and D, 70 and C, 80 and B, 90 and A. Keep the minimum scores in ascending order. With a 0–100 score in B2 and this table in E2:F6, enter in C2:
=IF(B2="","",VLOOKUP(B2,$E$2:$F$6,2,TRUE)). This returns D for 64 and A for 95. The dollar signs keep the table range fixed when you fill the formula down. For percentage scores, enter the thresholds in the same form, such as 0%, 60%, 70%, 80%, and 90%.
Common Mistakes
Mixing 0–100 scores with percentage values: An entry of 85 and an entry of 85% represent different numbers to Excel. Use cutoffs on the same scale as the input, or calculate a percentage first and use percentage cutoffs. If scores are displayed with a percent sign, check the formula bar or temporarily change the cell format to General to see the underlying value.
Putting grade tests in the wrong order: Nested IF tests should start at the highest cutoff and work down. If you test “greater than or equal to 60” first, a score of 95 also meets that test and may be assigned D. Check all the thresholds in descending order in the nested formula.
Using an unsorted lookup table: VLOOKUP with TRUE uses an approximate match and expects the first column of the lookup range to be sorted from smallest to largest. If it is not sorted, a lookup can return an incorrect grade. Also make sure the lookup range includes every threshold and its corresponding grade.
Assuming a universal grading policy: The sample cutoffs are only an example. Some courses use different boundaries, plus/minus grades, weighted categories, or rounding rules. Confirm the official rules and decide whether to round before assigning a grade; changing the displayed number format alone does not change the stored score.
Tips
- Keep the original score and the assigned grade in separate columns. That makes it easier to audit results and revise a cutoff without losing the underlying marks.
- Use a lookup table when the grading scale is likely to change. You can edit the cutoffs in one place instead of finding and replacing numbers inside multiple long formulas.
- For a quick visual scan, select the grade cells and use Home > Conditional Formatting to apply a color rule. Color should supplement the letter grade, not replace it, so the sheet remains understandable when printed or viewed without color.
- Protect against accidental text entries by selecting the score cells and choosing Data > Data Validation. Set Allow to Whole number or Decimal and specify a minimum and maximum appropriate to your scale, such as 0 and 100. For a true percentage scale, use decimal bounds of 0 and 1.
- Keep a short note near the table describing the grading policy, including whether the cutoffs are inclusive and whether scores are rounded. This helps another person understand why a borderline score received its grade.
- On Excel for Mac, enter the same formulas and use the fill handle as on Windows. Ribbon placement may vary by build, and keyboard shortcuts can differ; on Excel for the web, formulas and fill handles are also available in the browser.
Troubleshooting
The grade cell shows a formula instead of a result: The cell may be formatted as Text, or Excel may be set to display formulas. Change the cell format to General, re-enter the formula, and check that it starts with an equals sign. If formulas are being displayed throughout the sheet, toggle Show Formulas from the Formulas tab or press Ctrl+` on Windows. On a Mac, the shortcut can vary by keyboard layout, so use the Show Formulas control on the Formulas tab.
The result is wrong by one grade at a boundary: Confirm whether the cutoff should include the exact number. The examples use greater-than-or-equal comparisons, so 80 earns B. If your policy says a score must be greater than 80 to earn B, change that comparison to a greater-than test. Also check whether scores should be rounded first; a displayed 80 may actually be 79.6.
You see #N/A with the lookup method: Check that the score is at least the first threshold, that the first table column contains numbers, and that the threshold list is ascending. A negative score is below the example table’s first value of zero and has no approximate match. Correct the score or add a policy-appropriate lower threshold.
Every student receives the same grade or some grades are blank: Ensure each row’s formula refers to that row’s score, and confirm that the score cells contain numeric values rather than text. Click a grade cell and inspect its formula; after filling down, a formula in C3 should refer to B3. For the lookup method, check that the table range is fixed with dollar signs so it does not slide as the formula is copied.
Frequently Asked Questions
How do I assign plus and minus grades?
Use additional cutoffs in the nested formula or add more rows to the lookup table. For example, decide the boundaries for A-, B+, and the other grades first, then test from highest to lowest in a nested formula or list every minimum in ascending order in the lookup table. Make the policy explicit for exact cutoff scores.
Can Excel calculate a letter grade from several assignments?
Yes. First calculate the overall score according to the course rules, such as a weighted average when categories have different weights, and then apply the grade formula to that result. Do not simply average assignment percentages if the assignments have different possible points or weights unless that is the intended policy.
Why does 90% get an F with my formula?
The score may be stored as 0.9 while your formula compares it with 90. Use percentage cutoffs such as 90%, or convert the score to a 0–100 value consistently. Avoid mixing the two systems in the same calculation.
Can I use the formula for a score out of 20 or 50?
Yes, but either convert the score to a percentage first or change the grade cutoffs to match that total. For example, a 90% cutoff on a test out of 50 is 45 points. Converting to a percentage is usually clearer when tests have different maximum scores.
Does changing the number of decimal places round a grade?
No. Number formatting changes only how a value is displayed. If the grading policy requires rounding, use a deliberate rounding calculation before assigning the letter grade, and follow the course’s stated rounding rule rather than assuming Excel’s displayed value is the value used by the formula.
Related
- How to Export an Active Directory User List to Excel
- Export Excel to Word: Copy Tables Without Losing Format
- How to Exit Group Edit Mode in Excel and Ungroup Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Customer Call List Excel: Setup, Columns, and TipsYes. A customer call list in Excel is a structured worksheet for tracking who to contact, why, when,…
- Using Google Sheets for Beginners: A Practical GuideTo use Google Sheets as a beginner, open sheets.google.com, create a blank spreadsheet, enter information in cells, and…
- How to Change X and Y Axes in an Excel PivotChartTo change what appears on an Excel PivotChart’s X and Y axes, select the chart, open its PivotChart…
- How to Delete an Excel File SafelyTo delete an Excel file on Windows, close it, find it in File Explorer, select it, and press…
- Google Sheets Checkbox Format: Setup, Values, and TipsIn Google Sheets, select the cells where you want boxes, then choose Insert > Checkbox. A checkbox is…
- Excel Not Responding? Close It Safely and Recover WorkIf Excel says “Not Responding,” first wait briefly if it may be calculating or opening a large file;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.