IF + AND
Branch on multiple conditions at once
When to reach for this
Approve a bonus only when sales > $50K AND attendance ≥ 95%.
=IF(AND(B2>50000, C2>=0.95), "Bonus", "No bonus")What this pattern does
Nests AND inside IF so both conditions must be true for the yes-branch to fire. Perfect for qualification rules, like awarding a bonus only when sales cross a threshold AND attendance is good.
Interactive walkthroughWalk through IF
IF + AND lets you branch on multiple conditions at once. All conditions must pass for the yes-branch to fire. Watch it decide a bonus, step by step.
AND(B2>50000, C2>=0.95)logical_testTwo conditions combined with AND, both must be TRUE
"Bonus"value_if_trueWhat IF returns when AND is TRUE
"No bonus"value_if_falseWhat IF returns when AND is FALSE
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Employee | Sales | Attendance | ||
| 2 | Sarah Chen | $72,000 | 97% | =IF(AND(B2>50000, C2>=0.95), "Bonus", "No bonus") | |
| 3 | James Wu | $45,000 | 99% | ||
| 4 | Maria Lopez | $55,000 | 92% | ||
| 5 | Tom Brown | $62,000 | 96% | ||
| 6 | Anika Patel | $80,000 | 98% |
You type the combo formula
Bonus rule: sales > $50K AND attendance ≥ 95%. You're evaluating Sarah in D2: B2 = 72,000 and C2 = 97%. Excel always resolves the innermost function first, so AND runs before IF.
Key takeaway
Choose AND vs OR: use AND when all conditions must be true. Swap to OR when any one condition is enough to trigger the true branch.