Logical Functions
AND function
The AND function checks whether the logical values you enter are TRUE or FALSE and returns TRUE if all the arguments are TRUE.
FALSE function
The FALSE function returns the logical value FALSE and does not require any argument.
IF function
The IF function checks a logical expression and returns one value if it is TRUE, or another if it is FALSE.
IFERROR function
The IFERROR function checks whether the formula in the first argument returns an error and returns the formula result, or the value_if_error if there is an error.
IFNA function
The IFNA function returns the value you specify if the formula returns the
IFS function
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
NOT function
The NOT function checks whether the logical value you enter is TRUE or FALSE and returns the opposite value.
OR function
The OR function checks whether the logical values you enter are TRUE or FALSE and returns TRUE if at least one of the arguments is TRUE.
SWITCH function
The SWITCH function evaluates one value against a list of values and returns the result corresponding to the first matching value, or an optional default value if there is no match.
TRUE function
The TRUE function returns the logical value TRUE and does not require any argument.
XOR function
The XOR function returns a logical Exclusive Or of all arguments, that is TRUE when the number of TRUE inputs is odd and FALSE when it is even.