# Excel logical functions

> Logical functions make decisions: flag late orders, pick a shipping rate, show a blank instead of an error.

Source: https://spreadsheetpractice.com/functions/category/logic · Updated October 29, 2026

Logical functions make decisions: flag late orders, pick a shipping rate, show a blank instead of an error. IF does most of the work. AND, OR and NOT build the tests it checks, IFS and SWITCH replace long chains of nested IFs, and IFERROR and IFNA keep errors out of finished reports.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Return one result if a test passes and another if it fails | [IF](https://spreadsheetpractice.com/functions/if) | The core decision function. Everything else in this group feeds it or replaces it. |
| Require several conditions at once | [AND](https://spreadsheetpractice.com/functions/and) | Put it inside IF: =IF(AND(B2>=50,C2="Yes"),"Free","Paid"). |
| Pass when any one of several conditions is true | [OR](https://spreadsheetpractice.com/functions/or) | One TRUE is enough, which suits "big order or member" rules. |
| Pick from three or more outcomes without nesting | [IFS](https://spreadsheetpractice.com/functions/ifs) | A flat list of tests checked in order. The first TRUE one wins. |
| Turn exact codes into labels or numbers | [SWITCH](https://spreadsheetpractice.com/functions/switch) | Cleaner than IFS when every test is "equals this value". |
| Show a blank or a message instead of an error | [IFERROR](https://spreadsheetpractice.com/functions/iferror) | Use IFNA instead when only missing lookups should be hidden. |

## All 11 logical functions

| Function | What it does | Available in |
|---|---|---|
| [AND](https://spreadsheetpractice.com/functions/and) | AND returns TRUE only when every condition you give it is TRUE. | Every current version |
| [CHOOSE](https://spreadsheetpractice.com/functions/choose) | CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on. | Every current version |
| [IF](https://spreadsheetpractice.com/functions/if) | IF checks a condition and returns one value when it is true and another when it is false. | Every current version |
| [IFERROR](https://spreadsheetpractice.com/functions/iferror) | IFERROR returns a value you choose when a formula results in an error, and the formula's normal result otherwise. | Every current version |
| [IFNA](https://spreadsheetpractice.com/functions/ifna) | IFNA returns a fallback only when a formula results in #N/A, the error lookups give when a value is missing. | Excel 2013 and later |
| [IFS](https://spreadsheetpractice.com/functions/ifs) | IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE. | Excel 2019 and later, including Microsoft 365 |
| [LET](https://spreadsheetpractice.com/functions/let) | LET gives names to values or calculations inside a single formula, then uses those names in a final calculation. | Excel 2021, 2024 and Microsoft 365 |
| [NOT](https://spreadsheetpractice.com/functions/not) | NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE. | Every current version |
| [OR](https://spreadsheetpractice.com/functions/or) | OR returns TRUE when at least one of its conditions is TRUE. | Every current version |
| [SWITCH](https://spreadsheetpractice.com/functions/switch) | SWITCH compares one value against a list of exact matches and returns the result paired with the first match, with an optional default at the end. | Excel 2019 and later, including Microsoft 365 |
| [XOR](https://spreadsheetpractice.com/functions/xor) | XOR returns TRUE when an odd number of its conditions are TRUE. | Excel 2013 and later |

## Comparisons

- [IFERROR vs IFNA](https://spreadsheetpractice.com/functions/compare/iferror-vs-ifna): Both replace an error with something friendlier. IFNA only catches #N/A, the "not found" error from lookups; IFERROR catches every error, including ones that point to real mistakes.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
