Markup vs Margin Explained
Margin and markup are closely related—but not interchangeable. Mixing them up can cause under- or over-pricing, misreported profitability, and confused teams. This guide shows definitions, conversions, worked examples, Excel/Sheets snippets, and common mistakes.
Margin and Markup
Margin% = (Price − Cost) ÷ Price × 100
Markup% = (Price − Cost) ÷ Cost × 100
Example: Cost = $100; Markup 50% → Price = 100 × (1 + 0.5) = $150.
Margin at $150 is 50 ÷ 150 = 33.3% (not 50%).
Excel/Sheets: Margin → =(Price-Cost)/Price; Markup → =(Price-Cost)/Cost then format as %.
Converting Between Margin and Markup
- Given Margin%, Markup% = Margin% ÷ (1 − Margin%)
- Given Markup%, Margin% = Markup% ÷ (1 + Markup%)
Quick table (rounded):
| Margin% | Equivalent Markup% | Markup% | Equivalent Margin% |
|---|---|---|---|
| 20% | 25% | 20% | 16.7% |
| 30% | 42.9% | 40% | 28.6% |
| 40% | 66.7% | 50% | 33.3% |
| 50% | 100% | 100% | 50% |
Convert instantly with the Markup & Margin Calculator—it solves for price, margin, or markup in one click.
Worked Examples
1) Find Price from Cost + Target Margin
You need a 40% margin on a product that costs $60.
Price = Cost ÷ (1 − Margin) = 60 ÷ (1 − 0.40) = $100.
2) Find Margin Given Cost & Price
Cost $75, Price $120 → Margin% = (120 − 75) / 120 = 37.5%.
3) Find Price from Cost + Markup
Cost $80, Markup 35% → Price = 80 × (1 + 0.35) = $108; Margin = 28 / 108 = 25.9%.
Excel/Sheets tips:
=A2/(1-B2) (price from cost in A2 and margin% in B2),
=A2*(1+B2) (price from cost + markup%),
=(B2-A2)/B2 (margin from cost & price).
When to Use Margin vs Markup
- Use margin for P&L reporting, profitability analysis, and targets presented to leadership.
- Use markup to build selling prices from known costs (wholesale lists, retail keystone rules, catalog pricing).
- Convert between them when teams use different conventions to keep pricing aligned.
Common Mistakes
- Assuming markup% equals margin%—it never does, except at 0% and 100%.
- Calculating on tax-inclusive prices or forgetting shipping, fees, or rebates in cost.
- Stacking discounts and expecting them to add arithmetically (20% + 10% ≠ 30%).
- Not updating prices when input costs change (markup holds constant while margin erodes).
Frequently Asked Questions
Is 50% markup the same as 50% margin?
No. 50% markup on $100 cost → $150 price. Margin is $50 ÷ $150 = 33.3%.
How do I hit a target margin when I know my cost?
Use Price = Cost ÷ (1 − Margin) or the calculator to solve it instantly.
Should I set guardrails for discounts?
Yes—use margin floors to prevent discounts from pushing products below your target profitability. If tax applies, set rules on pre-tax prices.