Logical operators
Logical operators can build compound conditions into a formula, such as two or more conditions that must be met before you choose a particular method of calculation. With logical operators, you can describe such combinations of conditions.
Use AND, OR,
or XOR
with two expressions; use NOT
with one expression.
Symbol |
Definition |
AND |
True only if both items are true |
OR |
True if either item is true |
XOR |
True if either of the expressions (but not both) is true |
NOT |
Changes the value from False to True or from True to False |
Examples
Use ApplicationReceived="Y" AND FeePaid>0
if you want something to occur only if you have received both the application AND the fee.
Use CurrentBalance
≤0 OR CreditApproved="Y"
if you want something to occur only if no money is owed, OR credit has been approved, OR both are true.
Use FeePaid>0 XOR FreeGift="Y"
if you want something to occur only if EITHER a fee has been paid or a free gift has been sent, but not both (for example, if a fee has not been paid and a free gift has been sent).
Use NOT IsEmpty(FieldName)
to identify records that have a value in the FieldName field.