What it does
IFS takes pairs of conditions and values: =IFS(B2>=85,"A",B2>=70,"B",B2>=50,"C"). Excel tests the conditions from left to right, returns the value next to the first TRUE one and ignores the rest. That is why thresholds are written from the highest down.
Unlike IF, there is no "otherwise" slot: if none of the conditions is true, you get #N/A. To avoid it, end with the pair TRUE,"…"; TRUE is always true, so that value comes back when nothing else matched.
If you are comparing one value with fixed options ("C" for cash, "D" for card), SWITCH is shorter. When there are many bands that change often, put the thresholds in a table and use approximate match with VLOOKUP or XLOOKUP; it is easier to maintain. In Excel 2016 and earlier, use nested IFs.
Syntax
=IFS(logical_test1, value1, ...)=ÇOKEĞER(koşul1; değer1; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
logical_test1 | Required | The first condition, one that results in TRUE or FALSE, e.g. B2>=85. |
value1 | Required | The value returned if logical_test1 is true. Further pairs follow as logical_test2, value2; up to 127 pairs are allowed. |
Examples
1A four-level letter grade from a score
The conditions start from the highest threshold, and the letter of the first true one is returned. The final TRUE pair gives an F to anyone below every threshold.
=IFS(B2>=85,"A",B2>=70,"B",B2>=50,"C",TRUE,"F")| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Grade |
| 2 | Mia | 92 | A |
| 3 | Lucas | 85 | A |
| 4 | Ella | 70 | B |
| 5 | Jack | 64 | C |
| 6 | Leo | 38 | F |
- C2 (filled down to C6)
=IFS(B2>=85,"A",B2>=70,"B",B2>=50,"C",TRUE,"F")
Lucas scored exactly 85, so the first test is true: A. Jack's 64 is caught by the third test: C. Leo is below every threshold, so the last pair returns F.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Show a status from the stock level
"Out of stock" at 0, "Reorder" below the minimum level, "Running low" below 1.5 times the minimum, "OK" otherwise. The order matters: zero stock is also below the minimum, so it is tested first.
=IFS(B2=0,"Out of stock",B2<C2,"Reorder",B2<C2*1.5,"Running low",TRUE,"OK")| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Stock | Minimum | Status |
| 2 | Notebook | 0 | 50 | Out of stock |
| 3 | Pen | 35 | 100 | Reorder |
| 4 | Binder | 140 | 60 | OK |
| 5 | Eraser | 60 | 60 | Running low |
| 6 | Stapler | 12 | 10 | Running low |
- D2 (filled down to D6)
=IFS(B2=0,"Out of stock",B2<C2,"Reorder",B2<C2*1.5,"Running low",TRUE,"OK")
For the notebook the first test is true, so the rest are skipped: Out of stock. The eraser is exactly at its minimum, so "Reorder" does not apply and the next test does: Running low. The binder triggers no warning: OK.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #N/A
Cause: None of the conditions was true.
Fix: Add
TRUE,"Other"as the last pair.- Wrong band
Cause: The conditions start from the lowest threshold;
B2>=50is tested first, so a score of 92 also gets C.Fix: Order the thresholds from highest to lowest.
- #NAME?
Cause: The file was opened in a version without IFS (Excel 2016 or earlier).
Fix: Use nested IF for those versions.
Good to know
In Nexell
Get Nexell to do it from a sentence
Add a letter grade column to the exam list: A for 85 and above, B for 70 and above, C for 50 and above, F for the rest
Convert to tableBring your list into the tool and type this. Nexell adds the grade column with real Excel formulas and shows each student's grade in the preview; in the downloaded file, the grade changes when the score does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between IFS and nested IF?
Both give the same result. With nested IF, each new condition goes into the value_if_false part of the previous one and the brackets pile up; IFS lists all conditions at one level. IFS has no "otherwise" slot, so end it with a TRUE pair.