AND function
AND returns TRUE when every logical test is true.
Logical
Where can you use it?
Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.
Scenario in the workbook
Require both checks to pass before shipping.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | First value | Second value |
| 7 | TRUE | TRUE |
| 8 | TRUE | FALSE |
| 9 | FALSE | FALSE |
=AND(A7,B7)Expected resultTRUE
See the inputs and instructions for all 3 examplesCopyable formulas
=AND(A2>=8,B2="Approved")=VE(A2>=8;B2="Onaylı")Sample data
Enter the headers and sample records in A1:B4.
| Hours | Approval |
|---|---|
| 8 | Approved |
| 9 | Pending |
| 7 | Approved |
Fill down through C4.
Enter the formula in C2.
To try the Turkish formula, use the sample data on the Turkish page.
Expected result
TRUE, FALSE, FALSE
How it works
The first row meets both conditions. The second fails the approval check and the third fails the hours check. To show a text label, use AND as the first argument to IF.
Syntax
AND(logical1, [logical2], …)
Compatibility
Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.
Related pages
Worked examples
Require both checks to pass before shipping.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | First value | Second value |
| 7 | TRUE | TRUE |
| 8 | TRUE | FALSE |
| 9 | FALSE | FALSE |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =AND(A7,B7) |
TRUE |
| Record 2 | =AND(A8,B8) |
FALSE |
| Record 3 | =AND(A9,B9) |
FALSE |