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