Add a markup to a cost price
PremiumIn D2, work out the selling price of the mug: the cost in B2 plus the markup in C2, which is a percentage of the cost. Use B2*(1+C2).
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Cost | Markup | Price | ||
| 2 | Mug | 40 | 0.5 | |||
| 3 | Plate | 60 | 0.35 | |||
| 4 | Bowl | 52 | 0.25 | |||
| 5 | Vase | 180 | 0.4 | |||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Percentages 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:IFAND and OR
Need help?
Why this works
A 50% markup means the price is the cost plus half the cost: 40 + 20 = 60. Multiplying by (1 + 0.5) does both in one step, since 1 keeps the cost and 0.5 adds the markup.
Common mistake: Adding the percentage to the price, B2+C2. That adds 0.5, not 50% of the cost.
The answer
- D2
=B2*(1+C2)
Multiply by 1 plus the percentage, for example =B2*(1+C2) or =B2*(1+25%).