IF vs IFS in Google Sheets
Short answer: Use IF for a single yes/no test. Use IFS when you have three or more conditions to check in order — it replaces ugly nested IFs with a clean list.
Copy the one most people want (IFS)
=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", TRUE, "F")
Checks conditions top to bottom and returns the first match. The final TRUE acts as the "otherwise" catch-all.
IF vs IFS — the differences that matter
| Aspect | IF | IFS |
|---|---|---|
| Conditions | One test, two outcomes (true / false). | Many tests, evaluated in order. |
| Nesting | You nest IFs for more branches — hard to read. | Flat list of condition/result pairs. |
| Default / else | The false argument. | Add TRUE, "default" as the last pair. |
| No match | Always returns something (the false value). | Returns #N/A if nothing matches and no TRUE catch-all. |
Which one should you use?
Use IF when…
A binary decision — pass/fail, in-stock/out, discount yes/no. Also fine nested once for a quick two-level choice.
Use IFS when…
Grading bands, tiered pricing, status ladders — anywhere you'd otherwise nest three or more IFs. Cleaner to read and edit.
Same task, both formulas
Return "Pass" when the score in A2 is 60 or more, otherwise "Fail".
=IF(A2>=60, "Pass", "Fail")
=IFS(A2>=60, "Pass", TRUE, "Fail")
For one test IF is shorter. IFS earns its place once you add more bands, e.g. distinction / merit / pass / fail.
FAQ
Does IFS need an else?
Not required, but add TRUE, "default" as the last pair or unmatched rows return #N/A.
Can I still nest IF instead of IFS?
Yes, and it works — but three or more levels get unreadable. IFS is the maintainable choice.
Does IFS check conditions in order?
Yes — top to bottom, returning the first TRUE. Put the most specific conditions first.
→ Google Sheets formulas cheat sheet — 34 copy-paste formulas