Tests whether two or more conditions are met.
Syntax
IF x AND y THEN z
where:
- x: Boolean argument to test
- y: Boolean argument to test
- z: Response value
Format
| Input Format | Output Format |
|---|---|
|
x: Boolean y: Boolean |
z: Number, text, list item, time period, date |
Arguments
The function uses the following arguments:
- x: Boolean: Expression that equates to a Boolean result.
- y: Boolean: Expression that equates to a Boolean result.
- z: Result: Number, text, list item, time period, date: line item, or expression result.
Constraints
The function has no constraints.
Excel equivalent
Example
IF x > 1000 AND y = Products.Bananas THEN 1 ELSE 0
The function returns 1 if line item x is greater than 1000 and line item y is Bananas.