1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. IF AND

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

Back to Top

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.

Back to Top

Similar functions