When you have more than two or three outcomes, nested IFs get ugly fast. IFS tests conditions in order and returns the first match — far easier to read and edit.
IFS stops at the first TRUE condition, so order them from most specific to the catch-all.
The example
Convert a numeric score into a letter grade band.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Grade |
| 2 | Ana | 95 | A |
| 3 | Ben | 85 | B |
| 4 | Cara | 58 | F |
The formula
Each pair is a test and the value to return if it's true:
How it works
Reading IFS:
- IFS checks each condition left to right and returns the result of the first one that is TRUE.
- Order matters — put the highest threshold first so a 95 doesn't match the 80 band by accident.
- End with
TRUE,"F"as a default so every value gets a result. - Without that final TRUE, a value matching nothing returns #N/A.
If you're testing one value against fixed matches (not ranges), SWITCH is even tidier.
Try it: interactive demo
Enter a score — IFS returns the matching grade band.
Variations
Same logic with nested IF
Older Excel without IFS can nest IFs — harder to read but identical results.
Exact-match version with SWITCH
When matching specific values, SWITCH avoids repeating the cell reference.
Pitfalls & errors
Leaving off the final TRUE,default returns #N/A for anything that matches no condition.
IFS does not have a built-in 'else' — the TRUE pair is how you create one. Conditions are also order-sensitive.
Practice workbook
Frequently asked questions
Which Excel versions have IFS?
Why do I get #N/A?
IFS or SWITCH?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class