Logical Functions

AND

Check whether all arguments are True, and returns True if all arguments are True.

BYCOL

This function applies a LAMBDA to each column and returns an array of the results.

BYROW

This function applies a LAMBDA to each row and returns an array of the results.

FALSE

This function returns the value for logical FALSE.

IF

This function performs a comparison and returns one of two provided values based on that comparison.

IFERROR

This function evaluates a formula and returns a value you provide if there is an error or the formula result.

IFNA

This function returns the value you specify if the formula returns the #N/A error value, otherwise returns the result of the formula.

IFS

This function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

LAMBDA

This function allows you to create and name custom reusable functions that can be called like any other function.

MAKEARRAY

This function returns a calculated array of a specified row and column size, by applying a LAMBDA function.

MAP

This function 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.

NOT

This function reverses the logical value of its argument.

OR

This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.

REDUCE

This function reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.

SCAN

This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.

SWITCH

This function evaluates one value (called the 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.

TRUE

This function returns the value for logical TRUE.

XOR

This function returns a logical exclusive or of all arguments.