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