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.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| IF | Return one value if a condition is true, another if false | ✔ | ✔ | ✔ | ✔ |
| IFS | Test several conditions in order without nesting IFs | ✔ | ✔ | ≈ | ✔ |
| AND | TRUE only if every condition is true | ✔ | ✔ | ✔ | ✔ |
| OR | TRUE if at least one condition is true | ✔ | ✔ | ✔ | ✔ |
| NOT | Reverse TRUE and FALSE | ✔ | ✔ | ✔ | ✔ |
| IFERROR | Replace an error with a value of your choice | ✔ | ✔ | ≈ | ≈ |
| SWITCH | Match a value against a list and return the paired result | ✔ | ✔ | ✔ | ≈ |
✔ built-in function ≈ works with a workaround formula ✘ not available