Archive

FALSE

Returns the logical value FALSE.

SWITCH

Evaluates an expression against a list of values and returns one of multiple possible result expressions.

OR

Checks whether one of the arguments is TRUE to return TRUE. The function returns FALSE if both arguments are FALSE.

NOT

Changes FALSE to TRUE, or TRUE to FALSE.

IFERROR

Evaluates an expression and returns a specified value if the expression returns an error; otherwise returns the value of the expression itself.

IF.EAGER

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Uses eager execution.

IF

Checks if a condition provided as the first argument is met. Returns one value if the condition is TRUE, and returns another value if the condition is FALSE.

COALESCE

Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.

AND

Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise returns false.