|
AND
|
Returns TRUE if all parameters are TRUE and FALSE otherwise.
|
|
FALSE
|
Returns FALSE.
|
|
IF
|
Returns one of the given values based on logical conditions.
|
|
IFBLANK
|
Returns a value unchanged if it is not blank and a different value
otherwise.
|
|
IFERROR
|
Returns a value unchanged if it is not an error and a different value
otherwise.
|
|
IFNA
|
Returns a value unchanged if it is not an #N/A (not available) error
and a different value otherwise.
|
|
IFS
|
Returns one of the given values based on logical conditions.
|
|
NOT
|
Negates the logical parameter and returns it.
|
|
OR
|
Returns TRUE if one or more values are TRUE and FALSE otherwise.
|
|
SWITCH
|
Tests a given parameter for equality against a list of parameters and
returns a parameter associated with the parameter which matched the
first parameter.
|
|
TRUE
|
Returns TRUE.
|
|
XOR
|
Returns TRUE if an odd number of parameters are TRUE and FALSE
otherwise.
|