Logical functions

NAMEDESCRIPTION

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

TITLEOPERATORSDESCRIPTION

AND

&&

Logical AND

OR

||

Logical OR

Last updated