Logical functions
NAME
DESCRIPTION
AND
Returns TRUE only if all the conditions are TRUE; otherwise, returns FALSE.
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 conditions 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