# AND

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.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help
1. Press CTRL+C.
2. In the worksheet, select cell A1, and press CTRL+V.
3. 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.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help
1. Press CTRL+C.
2. In the worksheet, select cell A1, and press CTRL+V.
3. 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)

Applies to:
Excel 2003