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