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.
IfError	It returns the expression if it does not contain error, otherwise it returns the specified value.
Ifs	It checks for correspondence with one or several conditions and returns value for the first condition, which is set to TRUE.
IIf	It checks condition.
IsEmpty	It returns TRUE if the argument refers to an empty cell, otherwise it returns FALSE.
IsErr	It checks if the value is error and differs from #N/A.
IsError	It checks if the value is error.
IsLogical	It checks if the value is logical.
IsNA	It checks if the value is #N/A.
IsNonText	It checks if the value is text.
IsNumber	It checks if the value is number.
IsText	It checks if the value is text.
True	It returns the logical TRUE.