Either condition with OR
PremiumShipping is free for Gold customers OR for orders of 500 or more. In D2, use IF with OR to show "Yes" or "No".
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Customer | Tier | Order total | Free shipping? | ||
| 2 | Ane | Silver | 650 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock AND and OR and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
It comes up in this mock test: Excel test for job interviews
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
Why this works
OR(test1, test2) is TRUE when at least one test is TRUE. Ane is not Gold, but 650 >= 500 is TRUE, so OR is TRUE and IF shows Yes.
Common mistake: Using AND when only one condition has to hold. OR is TRUE as soon as one test is TRUE.
The answer
- D2
=IF(1OR(B2="Gold",C2>=500),2"Yes",3"No")
In plain words: 1If the tier in B2 is Gold or the order total in C2 is 500 or more, 2show Yes. 3Otherwise show No.