Home › Excel formulas › Logic functions
Excel Logic Functions: Full List with Examples
Logical functions let a formula make decisions. They test a condition and return different results, which is the base of almost every real report. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| IF | Returns one value if a condition is true, another if false. |
| IFS | Checks multiple conditions in order and returns the value for the first one that's true. |
| AND | Returns TRUE only if every condition given is true. |
| OR | Returns TRUE if at least one condition given is true. |
| NOT | Flips TRUE to FALSE and FALSE to TRUE. |
| XOR | Returns TRUE if an odd number of the given conditions are true. |
| IFERROR | Runs a formula, but shows a fallback value instead of an error if it fails. |
| IFNA | Like IFERROR, but only catches #N/A errors specifically. |
| SWITCH | Compares one value against a list of options and returns a matching result. |
| LAMBDA | Creates a custom, reusable function using Excel's own formula language. |
| LET | Assigns names to calculation results, so a formula can reuse them. |
| BYROW | Applies a LAMBDA to each row of an array and returns one result per row. |
| BYCOL | Applies a LAMBDA to each column of an array and returns one result per column. |
| MAP | Applies a LAMBDA to every item in an array and returns an array of results. |
| REDUCE | Reduces an array to a single accumulated value using a LAMBDA. |
| SCAN | Applies a LAMBDA to an array and returns each intermediate accumulated value. |
Practice Logic functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Logic functions?
Cellgrids lists 16 Excel Logic functions. Popular ones include IF, IFS, AND, OR, NOT. Each has its own page with syntax, arguments and an example.
How can I practice Excel Logic functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Logic function should a beginner learn first?
Start with IF. Returns one value if a condition is true, another if false.