How to Use AND Function in Excel: Simple Guide

Use the AND function in Excel to check if multiple conditions are all true. It returns TRUE if every condition is met, otherwise it returns FALSE. The syntax is =AND(condition1, condition2, ...).

Syntax

The AND function checks multiple conditions and returns TRUE only if all conditions are true. If any condition is false, it returns FALSE.

• condition1, condition2, ...: These are the logical tests you want to check. You can have 1 to 255 conditions.

excel

=AND(logical1, logical2, ...)

Output

TRUE or FALSE

Example

This example checks if a number in cell A1 is greater than 10 and less than 20. It returns TRUE only if both conditions are true.

excel

=AND(A1>10, A1<20)

Output

TRUE (if A1=15), FALSE (if A1=25)

Common Pitfalls

Common mistakes include:

• Using text instead of logical expressions inside AND.
• Forgetting that AND returns only TRUE or FALSE, not the values themselves.
• Not using parentheses properly when combining AND with other functions.

Example of wrong and right usage:

excel

Wrong: =AND("A1>10", "A1<20")
Right: =AND(A1>10, A1<20)

Quick Reference

Usage	Description
=AND(A1>5, B1<10)	Returns TRUE if A1 is greater than 5 AND B1 is less than 10.
=AND(C1="Yes", D1=100)	Returns TRUE if C1 equals 'Yes' AND D1 equals 100.
=AND(E1<>"", F1>=0)	Returns TRUE if E1 is not empty AND F1 is zero or more.

Key Takeaways

The AND function returns TRUE only if all conditions are true.

Use logical expressions (like A1>10) inside AND, not text strings.

AND can test multiple conditions at once, up to 255.

Combine AND with IF to perform actions based on multiple tests.

Remember AND returns TRUE or FALSE, not the values tested.