AND function

Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE.

Syntax

AND(logical1,logical2,...)

Logical1, logical2, ...     are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be column references that contain logical values.

• If a column reference argument contains text, AND returns the #VALUE! error value; if it is empty, it returns FALSE.

• If the arguments contain no logical values, AND returns the #VALUE! error value.

Example 1

Formula	Description (Result)
=AND(TRUE, TRUE)	All arguments are TRUE (Yes)
=AND(TRUE, FALSE)	One argument is FALSE (No)
=AND(2+2=4, 2+3=5)	All arguments evaluate to TRUE (Yes)

Example 2

Col1	Col2	Formula	Description (Result)
50	104	=AND(1<[Col1], [Col1]<100)	Because 50 is between 1 and 100 (Yes)
50	104	=IF(AND(1<[Col2], [Col2]<100), [Col2], "The value is out of range.")	Displays the second number, if it is between 1 and 100, otherwise displays a message (The value is out of range.)
50	104	=IF(AND(1<[Col1], [Col1]<100), [Col1], "The value is out of range.")	Displays the first number, if it is between 1 and 100, otherwise displays a message (50)