Returns the logical value TRUE or Yes if all of the arguments evaluate to TRUE; returns FALSE or No if one or more arguments evaluate to 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.
-
If one or more arguments contain #NULL!, AND returns #NULL!.
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) |
|
=AND(TRUE,#NULL!) |
One argument contains #NULL!(#NULL!) |
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), |
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) |
