Excel OR Practice Question: A customer is VIP if the level is Gold or Platinum and the spend is 1000 or…
The question
A customer is VIP if the level is Gold or Platinum and the spend is 1000 or more, otherwise Regular. Put it in D2 to D4.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Level | Spend | Type |
| 2 | Rahul | Gold | 1500 | ? |
| 3 | Priya | Silver | 2000 | ? |
| 4 | Amit | Platinum | 800 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- D2 = VIP
- D3 = Regular
- D4 = Regular
How it works
Explanation: OR checks the level (either one is fine), and AND then makes the spend condition necessary too.
Syntax: =IF(AND(OR(B2="Gold",B2="Platinum"),C2>=1000),"VIP","Regular")
Rahul is Gold with 1500: VIP. Priya is Silver: Regular. Amit is Platinum but spent only 800: Regular.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →OR syntax
Returns TRUE if at least one condition given is true. OR is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full OR guide.
More OR practice questions
- Write Weekend if the day is Sat or Sun, otherwise Weekday. Put it in C2 to C4.
- Write Out of range if the age is below 18 or above 60, otherwise OK. Put it in C2 to C4.
- Write West if the city is Pune or Mumbai, otherwise Other. Put it in C2 to C4.
- Give a Discount if the customer is a member (Yes) or the amount is above 5000, otherwise…
- Write Fail if any of the three marks is below 35, otherwise Pass. Put it in E2 to E4.
- Write Incomplete if the name or the city is empty, otherwise OK. Put it in C2 to C4.
- Count how many customers are from Pune or Surat (cities in B2:B6) and put the count in D2.
All practice questions · Excel exercises · Interview prep · Cheat sheet