Logical Functions (1)

Status	Function	Description
Not started	AND	Checks whether both arguments are `TRUE`, and returns `TRUE` if both arguments are `TRUE`.
Not started	BITAND	Returns a bitwise 'AND' of two numbers.
Not started	BITLSHIFT	Returns a number shifted left by the specified number of bits.
Not started	BITOR	Returns a bitwise 'OR' of two numbers.
Not started	BITRSHIFT	Returns a number shifted right by the specified number of bits.
Not started	BITXOR	Returns a bitwise 'XOR' of two numbers.
Not started	COALESCE	Returns the first expression that does not evaluate to BLANK.
Not started	FALSE	Returns the logical value `FALSE`.
Not started	IF	Checks a condition, and returns one value when `TRUE`, otherwise it returns a second value.
Not started	IF.EAGER	Checks a condition, and returns one value when `TRUE`, otherwise it returns a second value. Uses an eager execution plan which always executes the branch expressions regardless of the condition expression.
Not started	IFERROR	Evaluates an expression and returns a specified value if the expression returns an error
Not started	NOT	Changes `FALSE` to `TRUE`, or `TRUE` to `FALSE`.
Not started	OR	Checks whether one of the arguments is `TRUE` to return `TRUE`.
Not started	SWITCH	Evaluates an expression against a list of values and returns one of multiple possible result expressions.
Not started	TRUE	Returns the logical value `TRUE`.