← Back to level 1
Level 1Next
AND
A easy logic formula for situations where every condition must be true before the result is accepted.
Syntax
=AND(...)Step-by-step explanation
- 1List the logical tests that AND should evaluate before you finish the formula.
- 2Use AND when you need all conditions to be true, any condition to be true, or the result to be reversed.
- 3Check the final TRUE or FALSE output against a simple test case before copying it down.
Common mistakes
Expecting one true condition to be enough
Mixing text comparisons and numeric comparisons carelessly
Forgetting that every test must evaluate to TRUE
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=AND(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =AND(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use AND when a rule should pass only if all of its checks are met.
Match against the syntax block above.