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
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.