Complex Conditions
Table 11-10 Complex Conditions
Complex Conditions | Syntax | Logic |
---|---|---|
And |
|
Compares two conditions. Returns true if all conditions are true. Example:
|
Not |
|
Negates the result by reversing the result of the condition. Example:
|
Or |
|
Compares two conditions. Returns true if any of the conditions are true. Example:
|
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])