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.
Next with premium:COUNTIFSUMIF
Need help?
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.