Go to Contents  
Contents > Logical operators
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.
Related topic
About formulas

Contents > Logical operators