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