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.