AND Function in Excel: TRUE Only When All Conditions Are Met

📎 This article includes 1 downloadable practice file ↓

LogicalLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. AND in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

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.

AND in practice

Where you will use it

• Eligibility: marks above 40 AND attendance above 75%
• Approve a claim only if amount is within limit AND bills attached
• Flag invoices that are overdue AND above Rs 1 lakh

Worked example

Student	Marks	Attendance	Formula	Result
Aarav	78	0.82	=AND(B2>=40,C2>=0.75)	TRUE
Kabir	45	0.7	=AND(B3>=40,C3>=0.75)	FALSE
Meera	38	0.91	=AND(B4>=40,C4>=0.75)	FALSE

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Typing =A2>40 AND B2>75%	Excel has no AND operator; use AND(A2>40,B2>=75%) or (A2>40)*(B2>=75%)
Text numbers in the data	AND compares text '45' oddly; convert with VALUE

Related functions

OR · NOT · IF

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Logical guides →

TRUE Function in Excel: The Logical Value TRUETRUE() returns the logical value TRUE. You can also just type TRUE; the function…FALSE Function in Excel: The Logical Value FALSEFALSE() returns the logical value FALSE, most often seen as the exact-match argument in…MAKEARRAY Function in Excel: Generate a Grid From Row and Column NumbersMAKEARRAY builds an array of a given size, computing each cell from its row…BYCOL Function in Excel: Apply a Calculation to Each ColumnLogicalLevel: ExpertAvailable in: Excel 365 / 2021+BYCOL is BYROW turned sideways: one result per…

📎 Practice files for this article

• 📗
  Practice workbook: Logic, LET & LAMBDA17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.