Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
IF vs IFS: simplifying nested conditions in Excel and Sheets
Heads up: Excel and Google Sheets do this differently.
Excel
=IF(A2="High","Priority 1",IF(A2="Medium","Priority 2","Priority 3"))Google Sheets
=IFS(A2="High","Priority 1",A2="Medium","Priority 2",TRUE,"Priority 3")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Priority Label | Result |
| High | Priority 1 |
| Medium | Priority 2 |
| Low | Priority 3 |
| High | Priority 1 |
| Medium | Priority 2 |
=IF(A2="High","Priority 1",IF(A2="Medium","Priority 2","Priority 3"))→Priority 1
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell where you want the result and type = to begin your formula.
- 2For IF: type IF(logical_test, value_if_true, value_if_false) — nest another IF in the false argument for each additional branch.
- 3For IFS (Excel 2019+/Google Sheets): type IFS(condition1, result1, condition2, result2, TRUE, default) — the TRUE at the end acts as the catch-all else clause.
- 4Press Enter and copy the formula down to apply it to all rows.
Tips
- Always end an IFS formula with TRUE as the final condition and a default value — without it, IFS returns #N/A when no condition matches.
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Does IFS exist in all versions of Excel?
IFS was introduced in Excel 2019 and Excel 365. Users on Excel 2016 or earlier must use nested IF instead.
How many conditions can IFS handle?
IFS supports up to 127 condition-result pairs in Excel and Google Sheets.