Calculate a bonus with IF
PremiumSellers with sales over 1000 get a 10% bonus; everyone else gets 0. In C2, use IF to calculate the bonus for B2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Seller | Sales | Bonus | |||
| 2 | Sara | 1250 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock IF 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 assessment (Indeed format)
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
The value_if_true part of IF can be a calculation. 1250 > 1000, so IF returns 1250 × 0.1 = 125. Keep numbers out of quotes, or the result becomes text.
Common mistake: Putting the bonus in quotes, like "B2*0.1". Then IF returns the text instead of calculating it.
The answer
- C2
=IF(1B2>1000,2B2*0.1,30)
In plain words: 1If the sales in B2 are over 1000, 2the bonus is 10% of them. 3Otherwise it is 0.