Logical functions

Logical functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results.

In this section

Function Description
AND Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE.
FALSE Returns the logical value FALSE.
IF Checks if a condition provided as the first argument is met.
IFERROR Evaluates an expression and returns a specified value if the expression returns an error
NOT Changes FALSE to TRUE, or TRUE to FALSE.
OR Checks whether one of the arguments is TRUE to return TRUE.
SWITCH Evaluates an expression against a list of values and returns one of multiple possible result expressions.
TRUE Returns the logical value TRUE.