Description
Use this function to determine if all conditions in a test are TRUE. Supported in Chains. Can be used with CHILDREFS.
This function is designed to test multiple conditions simultaneously and return TRUE only if all conditions are met. If any condition isn't met it will return FALSE.
Syntax
AND(argument_1,[…,argument_255])
Inputs
This function has the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
argument_1 |
Yes | The first condition, text, or logical value to evaluate. | A cell, a cell range, a number, or a formula which results in any of these. |
argument_n |
Optional | Subsequent conditions, text, or logical values to evaluate. | A cell, a cell range, a number, or a formula which results in any of these. |
Example
Sample data
| A | B | |
|---|---|---|
| 1 | 11.16 | 79.59 |
| 2 | 19.28 | 86.97 |
| 3 | 96.73 | 43 |
| 4 | 66.18 | 55.08 |
| 5 | red | eggplant |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Display TRUE if the value in the specified cell is greater than 1 AND less than 100, otherwise display FALSE. | =AND(A2>1,A2<100) |
This formula works in the following manner:
For this data set this formula returns TRUE. (The value in A1 is greater than 1 and less than 100.) |
| Display TRUE if the value in the specified cell is less than A3 AND greater than 100, otherwise display FALSE. | =AND(A2<A3,A2>100) |
This formula works in the following manner:
For this data set this formula returns FALSE. (While the value in A2 is less than the one in A3, it is not greater than 100.) |
| Display TRUE if every value in the range B1:B5 is less than 100, otherwise display FALSE. | =AND(B2:B5<100) |
This formula works in the following manner:
For this data set this formula returns TRUE. (Every relevant value in the range B1:B5 is less than 100.) |
| Display TRUE if the value in the specified cell is the word "red", otherwise display FALSE. | =AND(A5="red") |
This formula works in the following manner:
For this data set this formula (corrected for syntax) returns TRUE. (The value in A5 is the word "red".) |
Notes
- AND can handle up to 255 separate conditions, which are entered as individual arguments separated by commas. Example:
AND A1>B1,C3=D4,F3="sold". - Text values used in comparisons must be enclosed in double quotes ("").
- AND evaluate numbers as TRUE or FALSE; any number except zero (0) is treated as TRUE.
- AND isn't case-sensitive.
- AND will return #VALUE! if no logical values are found or created during evaluation.
- If an empty cell is supplied as an argument, it's ignored.
- Wildcards don't work with this function.