Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument 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
Example 1
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

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

Example 2
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

A 
Data 
50 
104 
Formula 
Description (Result) 
=AND(1<A2, A2<100) 
Because 50 is between 1 and 100 (TRUE) 
=IF(AND(1<A3, A3<100), A3, "The value is out of range.") 
Displays the second number above, if it is between 1 and 100, otherwise displays a message (The value is out of range.) 
=IF(AND(1<A2, A2<100), A2, "The value is out of range.") 
Displays the first number above, if it is between 1 and 100, otherwise displays a message (50) 
