Excel OR Practice Question: Give a Discount if the customer is a member (Yes) or the amount is above 5000,…
The question
Give a Discount if the customer is a member (Yes) or the amount is above 5000, otherwise No discount. Put it in D2 to D4.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Amount | Member | Result |
| 2 | Rahul | 3000 | Yes | ? |
| 3 | Priya | 7000 | No | ? |
| 4 | Amit | 2000 | No | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- D2 = Discount
- D3 = Discount
- D4 = No discount
How it works
Explanation: The customer gets a discount for either reason, so OR is used.
Syntax: =IF(OR(C2="Yes",B2>5000),"Discount","No discount")
Rahul is a member: Discount. Priya spent 7000: Discount. Amit is neither: No discount.
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
=OR(logical1, [logical2], ...)
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.
- 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.
- A customer is VIP if the level is Gold or Platinum and the spend is 1000 or more,…
- 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