LogicalLevel: BeginnerAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Related functions
AND returns TRUE when every condition is TRUE. It is almost always used inside IF.
Syntax
=AND(logical1, [logical2], ...)
| Argument |
What it means |
logical1… |
Conditions to test (up to 255). |
Examples
Example 1
=AND(B2>=18, B2<=60)
Age within a range.
Example 2
=IF(AND(C2="Paid", D2<=E2), "On time", "Late")
Paid by the due date.
OR · NOT · IF
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong