IF vs IFS: When to Stop Nesting

Excel & Google Sheets

How it works

A nested IF buries each new tier one level deeper — =IF(B2>=90,"Gold",IF(B2>=75,"Silver","Bronze")) — and every added tier adds a parenthesis to balance at the end. IFS flattens the same logic into condition/result pairs read left to right, stopping at the first condition that's true. That stop-at-first-true rule does the range work for you: by the time IFS tests B2>=75, the >=90 case is already handled, so the pair order IS the logic — biggest threshold first. The one behavioral difference: nested IF's final else is built in, while IFS has none — if no condition matches, it returns #N/A. The fix is the TRUE catch-all as the last pair, which always matches and acts as the else. Both formulas produce identical tiers on the verified grid below. IFS needs Excel 2019/365 or Google Sheets; a single either/or is still cleaner as plain IF.

B2>=90,"Gold"

First pair, tested first — put the biggest threshold at the front.

B2>=75,"Silver"

Only reached when the Gold test failed, so it means 75 to 89.

TRUE,"Bronze"

The catch-all else. Without it, anything below 75 returns #N/A.

When to use it

Use IFS for commission tiers, grade bands, shipping brackets, and status labels — anywhere three or more outcomes stack. Keep plain IF for two-outcome checks like pass/fail or overdue/on-time.

Common mistakes

• ✕No catch-all, so unmatched rows show #N/A.

  ✓IFS has no built-in else. =IFS(B2>=90,"Gold",B2>=75,"Silver") returns #N/A for a 60. End with TRUE,"Bronze" to catch everything left.

• ✕Thresholds in the wrong order.

  ✓IFS stops at the first true pair. =IFS(B2>=75,"Silver",B2>=90,"Gold",...) traps a 92 at Silver because >=75 matched first. Order pairs from the strictest condition down.

• ✕Shipping IFS to Excel 2016 users.

  ✓IFS needs Excel 2019/365 or Google Sheets — older versions show #NAME?. For files that circulate widely, keep the nested IF; the logic is identical.