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

The AND function tests to see if all conditions are met.

Syntax

x AND y 

where:

  • x, y: value or expression to evaluate
AND(x, y, z)

where:

  • x, y, z: value or expression to evaluate

Back to Top

Format

Input Format Output Format

x: Boolean

y: Boolean

z: Boolean

Boolean

Arguments

The function uses the following arguments:

  • x: Boolean, or an expression that equates to a Boolean result
  • y: Boolean, or an expression that equates to a Boolean result
  • z: Boolean, or an expression that equates to a Boolean result

Constraints

The function has the following constraints:

  • Requires two or more Boolean equations.

Excel equivalent

Example

x > 1000 AND y >1000

When the formula is applied to a Boolean-formatted cell it results in a Boolean check box that is true (checked) when both x and y are greater than 1000.

Back to Top

Similar functions