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) |
|
