AND - Require every condition to pass
Combine budget and delivery requirements into a single TRUE/FALSE test before choosing an action.
By the end, you can
- Combine multiple comparisons with AND.
- Interpret TRUE and FALSE results.
- Distinguish AND from OR.
Before you start: Understand comparisons such as B2<=C2. IF converts a Boolean into a label.
In this lesson
Every requirement matters
Procurement accepts a quote only if it is within budget and delivery takes no more than five days. AND returns TRUE only when every supplied condition is TRUE. A cheap quote with late delivery fails, just as a quick but over-budget quote fails. AND itself returns a Boolean, not a supplier name or an approval label.
Syntax and arguments
=AND(logical1, [logical2], ...)Supply comparisons or logical values. Excel allows up to 255 arguments; clear reports usually need only a few.
| Argument | Purpose | Example |
|---|---|---|
logical1Required | The first condition or logical value. | B2<=C2 |
logical2, …Optional | More requirements, all of which must pass. | D2<=5 |
Budget and delivery screening
TRUE| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Supplier | Quote INR | Budget INR | Days | Both pass |
| 2 | Apex | ₹18,500 | ₹20,000 | 4 | TRUE |
| 3 | Bright | ₹17,200 | ₹20,000 | 7 | FALSE |
| 4 | Core | ₹21,000 | ₹20,000 | 3 | FALSE |
=AND(B2<=C2,D2<=5)Apex is within its ₹20,000 budget and can deliver within five days.
Test other rows and include more rules
=AND(B3<=C3,D3<=5)Bright passes the budget comparison but fails the delivery comparison, so AND is FALSE.
=AND(B2<=C2,D2<=5,D2>0)All three comparisons pass for Apex. Adding a check can catch impossible zero/negative durations.
=IF(AND(B2<=C2,D2<=5),"Shortlist","Review")IF translates the TRUE Boolean into Shortlist; it does not change the AND requirements.
Boolean values and errors
- TRUE requires all tests to pass. One FALSE is enough for an ordinary error-free AND result to be FALSE.
- Use explicit comparisons for numeric fields: nonzero numeric values can otherwise act as TRUE and zero as FALSE.
- Text and empty cells in a referenced range are ignored; if a range has no usable logical values, Excel can return #VALUE!.
- AND is not a safe guard against error-prone arithmetic. Do not assume a FALSE test prevents another argument's division error from being evaluated.
Common mistakes and fixes
Check your understanding
Choose an answer for instant feedback. You can try again; answers stay only on this page.