Excel AND Practice Question: Give a Bonus only if the sales are 100000 or more and the rating is 90 or…
The question
Give a Bonus only if the sales are 100000 or more and the rating is 90 or more, otherwise write No bonus. Put it in D2 to D4.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Sales | Rating | Result |
| 2 | Rahul | 120000 | 92 | ? |
| 3 | Priya | 150000 | 85 | ? |
| 4 | Amit | 90000 | 95 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- D2 = Bonus
- D3 = No bonus
- D4 = No bonus
How it works
Explanation: AND checks the sales and the rating together. Both must pass.
Syntax: =IF(AND(B2>=100000,C2>=90),"Bonus","No bonus")
Rahul passes both. Priya has a rating of 85. Amit has sales of 90000. Only Rahul gets the Bonus.
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 →AND syntax
Returns TRUE only if every condition given is true. AND is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full AND guide.
More AND practice questions
- A student passes only if both subject marks are 50 or more. Write Pass or Fail in D2 to…
- A person is eligible if the age is 18 or more and the city is Pune. Write Eligible or No…
- Write Ship if the status is Paid, the quantity is above 0 and the stock is In stock.…
- Write Average if the marks are between 40 and 60 (both included), otherwise Other. Put…
- Multiply price and quantity only if both are valid numbers and the quantity is above 0.…
- A code is valid if it starts with HR, has exactly 7 characters and ends with 4 digits.…
- Write All passed in E2 if every mark in B2:B6 is 40 or more, otherwise Someone failed.
- Years of service are in B2:B7 and the rating (1 to 5) in C2:C7. An employee gets a bonus…
All practice questions · Excel exercises · Interview prep · Cheat sheet