Logical Functions
AND
Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise …
COALESCE
Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to …
IF
Checks if a condition provided as the first argument is met. Returns one value if …
IF.EAGER
Checks whether a condition is met, and returns one value if TRUE, and another value …
IFERROR
Evaluates an expression and returns a specified value if the expression returns an error; otherwise …
NOT
Changes FALSE to TRUE, or TRUE to FALSE.
OR
Checks whether one of the arguments is TRUE to return TRUE. The function returns FALSE …
SWITCH
Evaluates an expression against a list of values and returns one of multiple possible result …
FALSE
Returns the logical value FALSE.
TRUE
Returns the logical value TRUE.