AND
Syntax
AND (condition, condition[, condition, ...])
Description
Returns True if all conditions in the formula are true; otherwise returns False.
Arguments
| condition | Two or more logical expressions that can be evaluated to True or False. |
Returns
Boolean True if all conditions are true; otherwise returns Boolean False.
Remarks
You can also use the And operator, && , within formulas.
Examples
If MyEntity.State contains the value "NH" and MyEntity.PostalCode contains the value "03104", then:
Given the above, the following formula:
IF(AND(MyEntity.State = "MA", MyEntity.PostalCode = "03104"), TRUE, FALSE)
Returns: FALSE
And the following formula:
IF(MyEntity.State = "NH" && MyEntity.PostalCode = "03104", TRUE, FALSE)
Returns: TRUE