Complex Conditions

Table 10-11 Complex Conditions

Complex Conditions Syntax Logic

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.

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.

(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])