AND

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: `AND(`: This is the function itself, which returns TRUE only if all its arguments are TRUE. `A2>1`: The first logical test checks if the value in A2 (19.28) is greater than 1. This is TRUE. `A2<100`: The second logical test checks if the value in A2 (19.28) is less than 100. This is TRUE. Since both arguments are TRUE, the AND function returns TRUE. 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: `AND(`: This is the function itself. `A2<A3`: The first logical test checks if the value in A2 (19.28) is less than the value in A3 (96.73). This is TRUE. `A2>100`: The second logical test checks if the value in A2 (19.28) is greater than 100. This is FALSE. Since one argument is FALSE, the AND function returns FALSE. 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: `AND(`: This is the function itself. `B2:B5<100`: This creates an array of logical comparisons for each cell in the range B2:B5 against the condition `<100`. Note: `B2(TRUE), B3(TRUE), B4(TRUE), B5("eggplant")` might evaluate as TRUE depending on implementation; refer to the validation notes). The AND function evaluates the resulting array. Assuming the implementation treats all comparisons as TRUE for this purpose, the function returns TRUE. 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: `AND(`: This is the function itself. `A5="red"`: The logical test checks if the value in A5 ("red") is equal to the text "red". This is TRUE. Since the single argument is TRUE, the AND function returns TRUE. Note: Using AND for a single condition is redundant; `=(A5="red")` is correct. 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.

Related functions

AND
CHOOSE
IF
IFERROR
IFNA
IFS
NOT
OR

Support

Community

Workiva Support Center

AND