IFS Function in Excel, Google Sheets, Airtable & Notion
IFS takes pairs of condition and result and returns the result of the first condition that is TRUE. It replaces long chains of nested IFs.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)Excel 2019 / 365 |
| Google Sheets | ✔ Built in | IFS(condition1, value1, [condition2, value2, ...]) |
| Airtable | ≈ Workaround | IF(test1, value1, IF(test2, value2, ..., otherwise))Airtable has no IFS. Nest IF functions; the last IF's false result works as the default. |
| Notion | ✔ Built in | ifs(condition1, value1, condition2, value2, ..., else)The final argument without a condition is the default value. |
| Excel | =IFS(83 >= 90, "A", 83 >= 80, "B", 83 >= 70, "C", 83 >= 60, "D", TRUE, "F") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =IFS(83 >= 90, "A", 83 >= 80, "B", 83 >= 70, "C", 83 >= 60, "D", TRUE, "F") | open sheets.new ↗ |
| Airtable workaround | IF(83 >= 90, "A", IF(83 >= 80, "B", IF(83 >= 70, "C", IF(83 >= 60, "D", "F")))) | |
| Notion | ifs(83 >= 90, "A", 83 >= 80, "B", 83 >= 70, "C", 83 >= 60, "D", "F") |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Order matters: the bands are checked from highest to lowest, and the first TRUE condition wins.
Arguments
| Argument | What it means |
|---|---|
logical_test1 | The first condition to check. |
value_if_true1 | Returned if logical_test1 is TRUE. |
[logical_test2, value_if_true2], ... optional | More pairs, checked in order. Use TRUE as the last test to set a default. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=IFS(83>=90, "A", 83>=80, "B", 83>=70, "C", TRUE, "F") | B | 83 fails the first test and passes the second. | |
=IFS(45>=60, "Pass") | #N/A | No condition is TRUE and there is no default. | |
=IFS(45>=60, "Pass", TRUE, "Fail") | Fail | TRUE as the last test acts as "otherwise". |
Examples use Excel / Google Sheets syntax unless noted.
How IFS works
IFS evaluates its conditions from left to right and stops at the first one that is TRUE, so the order of the pairs matters. For grade or commission bands, test the highest band first (>=90, then >=80…). If you start with the lowest band, almost every value matches the first test.
The main gotcha is the missing default. When no condition is TRUE, Excel and Google Sheets return #N/A. Add TRUE, "Other" as the final pair to catch everything else, or wrap the formula in IFERROR. Notion's ifs() has a proper else argument: the last value without a condition.
Airtable has no IFS, so the copy button builds the equivalent nested IF. If you are matching exact values rather than ranges (status codes, regions, sizes), SWITCH is shorter in every app. For long band tables, a sorted lookup table with XLOOKUP or VLOOKUP in approximate-match mode is easier to maintain than a formula.
Frequently Asked Questions
- Why does IFS return #N/A?
- None of the conditions was TRUE. Add
TRUE, "default"as the last pair. - Does IFS work in older Excel?
- No. IFS needs Excel 2019 or Microsoft 365. In Excel 2016 and earlier, nest IF functions instead.