Function Problems

How to Use Excel IFS Function to Return Letter Grades for Score Ranges

Phi Hung VoPhi Hung Vo Oct 28, 2026 871 views

Question details

The user needs to evaluate numerical values and return specific letter grades based on predefined score brackets using Excel formulas.

How to Use Excel IFS to Return a Letter Grade for Score Ranges
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cell

Click on the cell where you want the corresponding letter grade to be displayed (for example, cell B1 next to the score in A1).

2
Enter the IFS formula

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").

3
Apply and drag

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 the IFS Function for Multiple Score Ranges
Handling Unmatched Values: If a score falls outside all the specified ranges, the formula will return an #N/A error. To return a blank instead, wrap the entire formula in an IFERROR function, like this: =IFERROR(IFS(...), "").
Powerful Spreadsheet Tool

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. 1. Open your data file: Launch WPS Spreadsheet and open the document containing the numerical scores you need to grade.
  2. 2. Select the output cell: Click the cell adjacent to your first score where the letter grade should appear.
  3. 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. 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.
Fully compatible with Microsoft Excel (.xlsx) formulas, formatting, and functions.Free to download and use with a lightweight installation package.Features built-in formula builders and tooltips to help you write complex functions accurately.
QA img-9

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.