How to Use Excel IFS Function to Return Letter Grades for Score Ranges
Question details
The user needs to evaluate numerical values and return specific letter grades based on predefined score brackets using Excel formulas.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Categorizing data, such as grading student exam scores or evaluating performance metrics, where numerical inputs must be automatically translated into categorical letter grades.
- Observed behavior
- To achieve accurate grading, the user must apply the IFS function for assessing multiple score ranges, or use a standard IF function to evaluate a single range and return a blank value if the criteria are not met.
Verify that your version of Excel or WPS Spreadsheet supports the IFS function. The IFS function is available in Microsoft 365, Excel 2019 and later, and recent versions of WPS Office.
Use the IFS Function for Multiple Score Ranges
This is the most efficient method for assigning different letter grades across several specific numerical brackets without using complicated nested IF statements.
The IFS function evaluates multiple conditions in the order they are provided. By pairing it with the AND function, you can establish clear upper and lower bounds for each letter grade bracket.
Click on the cell where you want the corresponding letter grade to be displayed (for example, cell B1 next to the score in A1).
Type the formula combining IFS and AND logic to cover your ranges. For example: =IFS(AND(A1>=60,A1<=69),"C",AND(A1>=70,A1<=79),"B",AND(A1>=80,A1<=89),"A").
Press Enter to execute the formula. Click on the bottom-right corner of the cell and drag the fill handle down to apply the formula to the rest of your dataset.

Use a Standard IF Formula for a Single Range
If you only need to identify scores that fall into one specific bracket and leave all other cells blank, a regular IF statement is sufficient and simpler to write.
Calculate Grades Quickly with WPS Spreadsheet
WPS Spreadsheet fully supports advanced logical functions like IFS, IF, and AND, allowing you to categorize numerical data and assign letter grades efficiently without compatibility issues.
- 1. Open your data file: Launch WPS Spreadsheet and open the document containing the numerical scores you need to grade.
- 2. Select the output cell: Click the cell adjacent to your first score where the letter grade should appear.
- 3. Insert the IFS function: Go to the Formulas tab, click 'Insert Function', and search for IFS. Alternatively, type =IFS( directly into the cell.
- 4. Define your ranges: Input your logical conditions and corresponding letters (e.g., AND(A1>=80,A1<=89), "A") and press Enter to instantly calculate the grade.

Frequently Asked Questions
Why does my IFS formula return an #N/A error?
The #N/A error occurs when the referenced numerical value does not meet any of the logical conditions you specified in the IFS formula. You can prevent this by adding a final catch-all condition at the end of the formula, such as TRUE, "Not Found", or by wrapping the formula in an IFERROR function.
Can I use the IFS function instead of nested IF statements?
Yes, the IFS function was specifically designed to replace complex, deeply nested IF statements. It allows you to list multiple conditions consecutively, making your formulas much shorter, easier to read, and simpler to troubleshoot.
What if I use an older version of Excel that doesn't support the IFS function?
If the IFS function is unavailable on your software, you can achieve the exact same result by nesting standard IF functions. For example: =IF(A1>=80,"A",IF(A1>=70,"B",IF(A1>=60,"C","F"))). Evaluating the values from highest to lowest automatically acts as a boundary, eliminating the need to use the AND function.




