AND
Returns TRUE if all of its arguments are TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
Logical
Logical functions control how formulas behave based on conditions and rules.
They are the backbone of many Excel models because they define decision logic.
Logical functions are often combined with math, text, and lookup formulas.
Tips
- Use IFERROR to handle missing or invalid values.
- Keep logic readable by splitting complex conditions.
Excel functions in this category (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