Logical Functions Flashcards
NOT(logical)
Changes FALSE to TRUE, or TRUE to FALSE.
IF(logical_test, value_if_true[, value_if_false])
Checks a condition, and returns one value when it’s TRUE, otherwise it returns a second value.
IF.EAGER(logical_test, value_if_true[, value_if_false])
Checks a condition, and returns one value when TRUE, otherwise it returns a second value. It uses an eager execution plan which always executes the branch expressions regardless of the condition expression.
AND(logical1,logical2)
Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise returns false.
OR(logical1,logical2)
Checks whether one of the arguments is TRUE to return TRUE. The function returns FALSE if both arguments are FALSE.
SWITCH(expression, value, result[, value, result]…[, else])
Evaluates an expression against a list of values and returns one of multiple possible result expressions.
IFERROR(value, value_if_error)
Evaluates an expression and returns a specified value if the expression returns an error; otherwise returns the value of the expression itself.
BITAND(number, number)
Returns a bitwise AND of two numbers.
BITOR(number, number)
Returns a bitwise OR of two numbers.
BITXOR(number, number)
Returns a bitwise XOR of two numbers.
BITLSHIFT(Number, Shift_Amount)
Returns a number shifted left by the specified number of bits.
BITRSHIFT(Number, Shift_Amount)
Returns a number shifted right by the specified number of bits.
COALESCE(expression, expression[, expression]…)
Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.
FALSE()
Returns the logical value FALSE.
TRUE()
Returns the logical value TRUE.
