How to Use the AND Function in Excel

The AND function in Excel checks whether multiple conditions are TRUE at the same time. If every condition is TRUE, the function returns TRUE. If even one condition is FALSE, the function returns FALSE. The AND function is commonly used inside other formulas like IF statements to create more advanced logical tests for business reports, budgeting spreadsheets, inventory tracking, and data validation.

In This Guide, You’ll Learn

• What the AND function does
• The syntax and arguments of the AND function
• How to test multiple conditions at once
• How to combine AND with the IF function
• Common real-world uses for the AND function
• Mistakes to avoid when using AND formulas

What is the AND Function?

The AND function evaluates multiple logical conditions and returns TRUE only when all conditions are met.

For example, you can use AND to determine whether:

• A sales rep exceeded a sales target AND met a customer satisfaction goal
• An employee worked full-time AND completed required training
• Inventory is low AND a product is marked as active

AND Function Syntax

=AND(logical1, logical2, ...)

Argument Definitions

• logical1 — The first condition to evaluate
• logical2 — Additional conditions to test

Additional logical tests and results can continue as needed

Example Dataset Used in This Tutorial

You can download the sample data we’ll be using in this tutorial by clicking on this link—> AND Function Data

Basic AND Function Example

Imagine you want to check whether a student passed two required tests.

To test whether Sarah passed both exams with scores above 70:

=AND(B2>70,C2>70)

Result:

TRUE

Because both conditions are TRUE.

Using AND with the IF Function

The AND function becomes much more powerful when combined with the IF function.

Example: Bonus Eligibility

Suppose employees receive a bonus only if:

• Sales are greater than $50,000
• Customer rating is above 90%

Formula:

=IF(AND(B2>50000,C2>90),"Bonus","No Bonus")

Result for John:

Bonus

Result for Lisa:

No Bonus

Lisa failed one of the required conditions.

Using AND with Dates

The AND function is useful for checking whether dates fall within a specific range.

Example

Suppose cell A2 contains an order date.

You want to determine whether the date falls within the year 2026.

=AND(A2>=DATE(2026,1,1),A2<=DATE(2026,12,31))

If the date is within 2026, the result is TRUE.

Using AND for Inventory Tracking

The AND function is commonly used in inventory management.

Example

You want to identify products that:

• Have inventory below 10
• Are still marked as Active

Formula:

=AND(B2<10,C2="Active")

Result for Mouse:

TRUE

Common AND Function Errors

Using Text Without Quotes

Incorrect:

=AND(A1=Yes,B1>10)

Correct:

=AND(A1="Yes",B1>10)

Text values must always be enclosed in quotation marks.

Confusing AND with OR

• AND requires ALL conditions to be TRUE
• OR requires only ONE condition to be TRUE

AND vs OR Function

Function	Result
AND	TRUE only if all conditions are TRUE
OR	TRUE if at least one condition is TRUE

Example

=AND(A1>10,B1>10)

Both values must exceed 10.

=OR(A1>10,B1>10)

Only one value must exceed 10.

Example Dataset Used in This Tutorial

You can download the sample data we’ll be using in this tutorial by clicking on this link—> AND Function Data

Related Articles