Complex Conditions

Table 31. Complex Conditions

Complex Conditions

Syntax

Logic

And

(condition AND condition)

(condition & condition)

Compares two conditions. Returns true if all conditions are true.

Example:

(1 > 4 AND 5 > 2)

Returns false

Not

NOT (condition)

! (condition)

Negates the result by reversing the result of the condition.

Example:

Not (1 > 4)

Returns true

Or

(condition OR condition)

(condition | condition)

Compares two conditions. Returns true if any of the conditions are true.

Example:

(1 > 4 OR 5 > 2)

Returns true

Complex conditions And, Or, and Not are fully supported. However, they must be surrounded by parentheses.

Valid example:

If ( ([A] > [B] and [A] > 1000), [A], [B])

Invalid example:

If ( [A] > [B] and [A] > 1000, [A], [B])