Logical Functions

The list of predefined logical functions is given in the table below:

Function Brief description
_And It checks if all its arguments are TRUE and returns TRUE if they all are TRUE.
_Not It changes Boolean value of the argument to its opposite.
_Or It checks if at least one argument is TRUE; returns TRUE or FALSE.
False It returns the logical FALSE.
IIf It checks condition.
IsEmpty It returns TRUE if the argument refers to an empty cell, otherwise it returns FALSE.
True It returns the logical TRUE.

See also:

Function Wizard