AND
Returns TRUE if all of its arguments are TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
Logic & Conditions
Logic & Conditions functions let you turn business rules into formulas: branching logic, multi-condition checks, and readable decision models.
This collection groups Excel functions that are commonly used for logic & conditions workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (19)
BYCOL
Applies a LAMBDA to each column and returns an array of the results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
BYROW
Applies a LAMBDA to each row and returns an array of the results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
FALSE
Returns the logical value FALSE.
LogicalLogic & Conditions
IF
Specifies a logical test to perform.
LogicalBeginner EssentialsLogic & ConditionsMost Used
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
LogicalBeginner EssentialsError Handling & ChecksLogic & Conditions
IFNA
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
LogicalError Handling & ChecksLogic & ConditionsMost Used
IFS
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
LogicalLogic & ConditionsModern Excel FunctionsMost Used
LAMBDA
Create custom, reusable and call them by a friendly name.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
LET
Assigns names to calculation results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
MAKEARRAY
Returns a calculated array of a specified row and column size, by applying a LAMBDA.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
MAP
Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
NOT
Reverses the logic of its argument.
LogicalLogic & ConditionsMost Used
OR
Returns TRUE if any argument is TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
REDUCE
Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
SCAN
Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
SWITCH
Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
LogicalLogic & ConditionsModern Excel Functions
TRUE
Returns the logical value TRUE.
LogicalLogic & Conditions
XOR
Returns a logical exclusive OR of all arguments.
LogicalLogic & Conditions