The AND function in Excel
AND checks several conditions and returns TRUE only if all of them are true. If even one is false, the result is FALSE.
On its own it returns TRUE or FALSE. Most often it sits inside IF, so the result becomes a word or a number: "Pass", "Allowed", a bonus amount.
Syntax
=AND(logical1, [logical2], …)
| Argument | What it means |
|---|---|
| logical1 | The first condition, e.g. B2>=18. |
| logical2, …optional | More conditions. Up to 255. |
Examples
1. Are both conditions met?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Age | Consent | Can join |
| 2 | Noa | 19 | Yes | TRUE |
19 is at least 18 and consent is "Yes", so the result is TRUE.
2. Inside IF: pass only if both parts are passed
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Theory | Practice | Result |
| 2 | Liam | 72 | 45 | Retake |
Theory is fine, but practice (45) is below 50. One false condition is enough for AND to return FALSE.
3. Is a number between two values?
| A | B | |
|---|---|---|
| 1 | Temperature | 15 |
| 2 | Comfortable? | TRUE |
Two comparisons on the same cell. Excel has no "10 <= B1 <= 20" shortcut.
Common mistakes
Writing a range test like math, e.g.
=10<=B1<=20. Excel compares step by step and returns a wrong answer.Fix: Use
=AND(B1>=10,B1<=20).Mixing up AND and OR. "North or East" needs OR;
=AND(B2="North",B2="East")is never true.Fix: Use AND when every condition must hold, OR when one is enough.
Frequently asked questions
Can I use AND without IF?
Yes. It returns TRUE or FALSE, which is useful in conditional formatting rules and in filters.
How do I reverse a condition?
Wrap it in NOT: =NOT(B2="Cancelled") is TRUE for everything that isn't cancelled.