ExcelFlux

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

RowAB
6First valueSecond value
7TRUETRUE
8TRUEFALSE
9FALSEFALSE
Record 1
=AND(A7,B7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=AND(A2>=8,B2="Approved")
Turkish Excel · tr-TR
=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.

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
Microsoft Excel reference