Change a Boolean Operator in an Expression
You can change a Boolean operator in an expression by clicking one of the following buttons on the Infix Notation group box in the expression editor:
To change a Boolean operator in an expression
Note: To select multiple adjacent conditions, hold down the Shift key while clicking.
And/Or
Switches between the Boolean operators AND and OR.
Example:
AND condition_1
becomes
OR condition_1
Note: The AND/OR button switches XOR to AND.
Not
Switches between adding and removing the Boolean operator NOT.
Example:
AND condition_1
becomes
AND NOT condition_1
XOR
Switches the Boolean operators AND and OR to XOR.
Example:
AND condition_1
becomes
XOR condition_1
Note: The exclusive OR (XOR) operator takes two Boolean operands and returns TRUE if either operand is TRUE, but not both.
Conditional?YES:NO
Adds the conditional decision operator.
Example:
condition_1
becomes
condition_1 ? "YES" : "NO"
The edited expression is displayed in the fields on the Resulting Notation and Infix Notation group boxes in the expression editor.
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |