Excel AND Function (Multiple Conditions) – Examples & Practice
Practice the Excel AND function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Check whether both A2 is at least 85 and B2 is at least 90; return TRUE only if both tests pass.
Formula Syntax
=AND(logical1, [logical2], ...)
- logical1: First condition that evaluates to TRUE or FALSE.
- [logical2]: Optional additional conditions.
- ...: Up to 255 logical tests in one formula.
What it does
The AND function in Excel is used to test multiple conditions at the same time. It returns TRUE only when all conditions are met, and FALSE if any condition fails. This function is commonly used with IF to build logical formulas.
Excel AND Function Examples
Basic AND condition
=AND(A1>10, B1<20)
Returns TRUE if A1 is greater than 10 and B1 is less than 20.
AND with text values
=AND(A1="Yes", B1="Approved")
Returns TRUE only when both text conditions match.
AND inside IF
=IF(AND(A1>=50, B1>=50), "Pass", "Fail")
Returns "Pass" only when both conditions are met.
AND with dates
=AND(A1>=DATE(2024,1,1), A1<=DATE(2024,12,31))
Checks if a date falls within a specific range.
logical-checks.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Score | Attendance % | Approved |
| 2 | 92 | 96 | Yes |
| 3 | 78 | 88 | No |
| 4 | 85 | 91 | Yes |
| 5 | 66 | 84 | No |
| 6 | 90 | 93 | Yes |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use AND with clean, consistent comparisons so each argument clearly evaluates to TRUE or FALSE.
- Validate data types (number, text, date) before applying the formula.
- Test the formula on one row first, then copy down when the logic is correct.
AND Function Use Cases
- Validate rows where multiple conditions must be TRUE
- Check if a user meets all required criteria
- Filter data with strict rules (e.g. sales > target AND region = "US")
- Combine with IF to return custom results
- Use in conditional formatting for highlighting valid data
Common mistakes - AND function not working
- Expecting TRUE when only one condition is correct (AND requires all conditions)
- Comparing text incorrectly (extra spaces or wrong values)
- Using AND directly with ranges like
=AND(A1:A5>10) - Mixing data types (number vs text)
- Missing commas or parentheses in the formula
FAQ
Can I use AND with the IF function?
Yes. AND is often used inside IF to test multiple conditions before returning a result, such as marking data as valid or invalid.
How many conditions can AND handle?
The AND function can handle up to 255 conditions in a single formula.
Does AND work with text values?
Yes, but you must use explicit comparisons, such as checking if a cell equals a specific text value.
Why does AND return FALSE even when one condition is correct?
Because AND requires all conditions to be TRUE. If just one condition is FALSE, the entire result becomes FALSE.
Can AND be used with ranges?
It can, but results may not behave as expected in standard formulas. It is usually better to combine AND with functions like IF or SUMPRODUCT.
Comparison
| Function | Logic | When to use |
|---|---|---|
| AND | All conditions must be TRUE | Strict validation |
| OR | At least one condition must be TRUE | Flexible checks |
| IF | Returns values based on conditions | Decision making |
Example
=AND(A1>10, B1<20)
Returns TRUE only if both conditions are met
=OR(A1>10, B1<20)
Returns TRUE if at least one condition is met
=IF(AND(A1>10, B1<20), "OK", "Not OK")
Returns a result based on AND logic
Advanced examples
AND with multiple conditions
(1) Multiple conditions example — multiple conditions means stacking several logical tests in one AND; every test must be TRUE.
=AND(A1>10, B1<20, C1="Yes")
👉 Strong pattern for multiple conditions on the same row (for example: score above a floor, headcount under a cap, and status equals “Yes”).
Returns TRUE only if all three conditions are satisfied.
AND + OR combination
(2) Combo AND + OR — nest OR inside AND when one “slot” should allow alternatives while the rest stay strict.
=AND(A1>10, OR(B1="Yes", C1="Yes"))
🔥 Typical combo: value passes a threshold and (either column B or column C must read “Yes”).
Combines strict and flexible conditions.
Related functions
Use IF when AND only decides whether something is true—you still need IF to return numbers, text, or blanks based on that test.
Pair OR when you want “any condition passes” logic, and XOR when exactly-one-true rules matter.
For many ordered tests without deep nesting, IFS can be easier to read than long AND/IF chains.