Logical functions

Apply logical functions to test conditions and return TRUE or FALSE results.

NAME	DESCRIPTION
AND	Returns TRUE only if all conditions are TRUE.
IN	Returns TRUE if the specified value is one of the values in the list or array.
ISBLANK	Returns TRUE if the specified cell value is blank or empty.
ISEMPTY	Returns TRUE if the specified cell value is blank or empty. It works similar to ISBLANK.
ISNUMBER	Returns TRUE if the cell value is a valid number.
NOT	Returns the opposite logical value of the argument.
OR	Returns TRUE if any argument is TRUE; returns FALSE only if all arguments are FALSE.
XOR	Returns TRUE if the number of satisfied conditions is odd, and FALSE if it is even.
ISREFEXIST	Returns TRUE if the specified reference exists in the model.

Logical Operators

TITLE	OPERATORS	DESCRIPTION
AND	&&	Logical AND
OR	||	Logical OR
XOR	^	Logical Exclusive OR