Logical functions
NAME
DESCRIPTION
AND
Returns TRUE if all the conditions are TRUE
IN
Returns TRUE if the list of values being searched is in the array
ISBLANK
Returns the logical value TRUE if the value argument is a reference to an empty cell
ISEMPTY
Returns the logical value TRUE if the value argument is a reference to an empty cell
ISNUMBER
Returns the logical value TRUE if the value argument is a valid number
NOT
Changes FALSE to TRUE and TRUE to FALSE
OR
Returns TRUE if any of the arguments are TRUE and FALSE only if all arguments are FALSE
XOR
Returns a logical 'Exclusive OR' of all the arguments
Logical Operators
TITLE
OPERATORS
DESCRIPTION
AND
&&
Logical AND
OR
||
Logical OR
Last updated