Nested IF vs IFS in Excel: Which One to Use (With Examples)

Grading scores, pricing tiers, bonus bands — sooner or later every spreadsheet needs a formula that says “if this, then that, otherwise if that, then this”. The classic way is nested IFs, one inside another. The modern way is IFS, which lists the conditions flat. Both give the same answer, but one is far easier to read and to fix when it breaks.

What Nested IF vs IFS does

A nested IF puts a whole new IF inside the “value if false” slot of the previous one, building a chain that is read inside-out. IFS instead takes pairs of test-and-result and returns the first test that passes. The logic is identical; the difference is readability, and readability is what decides whether a formula survives contact with a colleague.

The syntax

=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","F"))) — vs — =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"F")

  • test — a comparison such as A2>=90. Tests are checked in order.
  • result — the value returned when that test passes.
  • TRUE — as the last IFS test, TRUE acts as the catch-all — it always passes, like the final “F” in a nested IF.

Step-by-step example

Grade this list of scores both ways and compare.

  1. Click the cell for the nested-IF grade.
  2. Type =IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F")))) — count the closing brackets carefully: one per IF.
  3. In the next column, type the IFS version: =IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",TRUE,"F").
  4. Press Enter on both. The grades match — now change a score and watch both update.
  5. To see the readability difference, click each formula and read it aloud. IFS reads top to bottom; nested IF reads inside out.

Worked example

Name Score Nested IF IFS
Mina 92 A A
Jae 58 F F
Sora 77 C C
Tom 84 B B

Both columns agree on every row — they are the same logic written two ways. The IFS column is shorter, has fewer brackets to miscount, and shows the thresholds in order, which is why it is the better default for new work.

Common errors

#VALUE! from IFS with no match. IFS returns #VALUE! when no test passes and there is no catch-all. Always end with TRUE,"fallback" as the last pair.

Missing closing bracket in nested IF. Each IF needs its own closing bracket, and they pile up at the end — four IFs means four ). If Excel complains, count the brackets; if you lose count, that is the sign to switch to IFS.

Wrong grade at the boundary. Check whether the boundary is >= or >. A score of exactly 80 is a B with >=80 and a C with >80. Test the boundary values, not just the middle ones.

IFS does not work in an old file. IFS needs Excel 2019 or Microsoft 365. In Excel 2016 and older it shows #NAME?. If the file must open in old Excel, nested IF is the safe choice.

Tip

For two outcomes, a single IF is clearest. For three or more, IFS wins on readability. And if the mapping is really a table (score bands to grades), skip both and use VLOOKUP with TRUE or XLOOKUP — a lookup table is easier to change than any formula.

When a lookup table beats both

Grade bands, tax brackets, and shipping tiers are all mappings from a range to a result — and a mapping belongs in a table, not in a formula. Put the thresholds in two columns (lowest score, grade) and use =VLOOKUP(B2,$A$10:$B$11,2,TRUE) with an approximate match, or XLOOKUP with match mode -1. The advantage is maintenance: when the pass mark moves from 60 to 65, you edit one cell in the table instead of hunting through every IF in the workbook. Formulas are for logic; tables are for data. The moment a number in your formula is really a policy that might change, move it into a cell.

Practice file

Download the Nested IF vs IFS practice file (.xlsx) — it contains a grading sheet with nested IF and IFS side by side, plus a blank sheet for you to try it yourself.

Google Sheets

Google Sheets supports both nested IF and IFS with the same syntax. Sheets also has SWITCH, which is cleaner still when you are matching exact values instead of ranges.

Example prices and figures are illustrative, not market data.