Markup & Margin Calculator
Enter your cost and selling price to get profit, margin %, markup %, and the margin ratio. Margin is profit as a % of price; markup is profit as a % of cost.
Tip: results update as you type. Negative values indicate a loss.
Copyable Excel & Google Sheets Formulas
Profit = Price − Cost. Example: =100-80 → 20.
Margin % = Profit ÷ Price × 100. Example: =(100-80)/100*100 → 20%.
Markup % = Profit ÷ Cost × 100. Example: =(100-80)/80*100 → 25%.
Price from target margin (C2 as decimal). Example: Cost=80, Target margin=0.2 → =80/(1-0.2) → 100.
Cell convention: A2 = Cost, B2 = Price, C2 = Margin as decimal (e.g., 0.2 for 20%).
Margin vs Markup (quick refresher)
- Margin % = (Price − Cost) ÷ Price × 100
- Markup % = (Price − Cost) ÷ Cost × 100
- Same numbers, different denominator — that’s why 20% margin corresponds to 25% markup on the same 80 → 100 example.
Need spreadsheet formulas? Use the copy buttons above or see our Percentage Formula page.
FAQs
What’s the difference between margin and markup?
Margin is profit as a percentage of the selling price. Markup is profit as a percentage of cost. They’re related but not the same.
How can I set a price to reach a target margin?
Enter your cost and target margin. The calculator will show the required selling price and the implied markup.
Why doesn’t 50% markup equal 50% margin?
Because margin is based on selling price and markup is based on cost. A 50% markup on a $100 cost gives a $150 price, which is a 33.3% margin.