Logical functions

Apply logical functions to test conditions and return TRUE or FALSE results. These functions are commonly used to evaluate expressions, validate data, and build conditional logic in reports.

In this category

Function	Description
AND	Returns TRUE only if all conditions are TRUE.
OR	Returns TRUE if any condition is TRUE; returns FALSE only if all conditions are FALSE.
NOT	Returns the opposite logical value of the argument.
XOR	Returns TRUE if the number of satisfied conditions is odd, and FALSE if it is even.
IN	Returns TRUE if the specified value exists in a list or array.
ISBLANK	Returns TRUE if the specified value is blank or empty.
ISEMPTY	Returns TRUE if the specified value is blank or empty. It works similar to ISBLANK.
ISNUMBER	Returns TRUE if the specified value is a valid number.
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