Spreadsheet formulas explained, side by side

Logical Functions

IF, IFS, AND, OR, SWITCH and error handling. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
IFReturn one value if a condition is true, another if false✔✔✔✔
IFSTest several conditions in order without nesting IFs✔✔≈✔
ANDTRUE only if every condition is true✔✔✔✔
ORTRUE if at least one condition is true✔✔✔✔
NOTReverse TRUE and FALSE✔✔✔✔
IFERRORReplace an error with a value of your choice✔✔≈≈
SWITCHMatch a value against a list and return the paired result✔✔✔≈

✔ built-in function   ≈ works with a workaround formula   ✘ not available