Quick Navigation

AND Function

Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365

Summary

The AND function is a fundamental logical tool in Excel that evaluates multiple conditions and returns TRUE only when every condition is met. It serves as a powerful building block for complex decision-making formulas, enabling multi-criteria analysis across worksheets.

Syntax

AND(logical1, [logical2], ...)

Parameters

Parameter	Type	Required	Description
logical1	`Logical`	Yes	Required first condition that must evaluate to TRUE or FALSE
logical2, ...	`Logical`	No	Optional additional conditions, up to 255 total arguments

Using the AND Function

AND excels at multi-condition testing, making it indispensable for data validation, conditional calculations, and decision trees. Use it within IF statements for sophisticated logic or with array formulas for bulk condition checking across datasets.

Common AND Examples

Basic Range Check

=AND(A2>10, A2<100)

Verifies if value in A2 falls between 10 and 100 (exclusive)

Multiple Criteria Bonus

=IF(AND(B10>=SalesGoal, C10>=AccountGoal), B10*BonusRate, 0)

Calculates bonus only when both sales and account targets are met

Date Range Validation

=AND(TODAY()>=StartDate, TODAY()<=EndDate)

Checks if current date falls within specified project period

Data Quality Check

=AND(A2<>"", B2<>"", C2>0)

Ensures no empty cells and positive value before processing

Frequently Asked Questions

Yes, AND automatically ignores text and blank cells in array/range arguments, processing only logical values.

Returns #VALUE! error if the range contains no TRUE/FALSE values.

Yes, AND works with arrays and returns TRUE only if ALL elements in the array evaluate to TRUE.

Common Errors and Solutions

#VALUE! Error

Cause: Range contains no logical values (only text/empty cells)

Solution: Ensure range contains TRUE/FALSE values or use ISNUMBER/ISTEXT filters

Unexpected FALSE result

Cause: Any single FALSE condition makes entire AND return FALSE

Solution: Verify each condition individually with separate formulas

Wrong argument count

Cause: Using more than 255 arguments

Solution: Limit to 255 conditions maximum

Notes

AND returns FALSE immediately upon encountering first FALSE condition (short-circuit evaluation)
Ideal companion for OR function in comprehensive logical testing
Use AND with SUMPRODUCT for array-based multi-condition counting
Arguments can be cell references, calculations, or direct TRUE/FALSE values

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365