Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inIFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
Excel 2019 / 365
Google Sheets✔ Built inIFS(condition1, value1, [condition2, value2, ...])
Airtable≈ WorkaroundIF(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 inifs(condition1, value1, condition2, value2, ..., else)
The final argument without a condition is the default value.
Try IFS with your own values
Anything lower gets F
Result (as Excel & Google Sheets return it)
B 1 character
Your formula, ready to paste
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"))))
Notionifs(83 >= 90, "A", 83 >= 80, "B", 83 >= 70, "C", 83 >= 60, "D", "F")

Order matters: the bands are checked from highest to lowest, and the first TRUE condition wins.

Arguments

ArgumentWhat it means
logical_test1The first condition to check.
value_if_true1Returned if logical_test1 is TRUE.
[logical_test2, value_if_true2], ... optionalMore pairs, checked in order. Use TRUE as the last test to set a default.

Examples

FormulaResultWhyCopy
=IFS(83>=90, "A", 83>=80, "B", 83>=70, "C", TRUE, "F")B83 fails the first test and passes the second.
=IFS(45>=60, "Pass")#N/ANo condition is TRUE and there is no default.
=IFS(45>=60, "Pass", TRUE, "Fail")FailTRUE 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.

Part of the Logical functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.