If you've ever set a price using a markup percentage and assumed your gross margin percentage would match, this is for you. The margin versus markup calculation works differently depending on which number sits in the denominator, and confusing the two is how founders quietly underprice products by double digits. We're going to cover the markup vs margin formula, a margin versus markup chart, real examples, conversion tables, and how to build a margin vs markup calculator in Excel so the math stops being a guessing game.
TLDR:
Profit margin tells you how much of each revenue dollar survives after covering the cost of what you sold. The formula:
Profit Margin = (Revenue - Cost) / Revenue × 100
Take a product that sells for $100 with a $60 cost. The math: ($100 - $60) / $100 × 100 = 40%.
The denominator is what defines margin. Revenue sits at the bottom, so margin always measures profit as a share of what came in. A 40% margin means 40 cents of every dollar earned is profit. That framing, anchored to revenue, is what separates margin from every other way of expressing profitability.
Markup also starts from the gap between revenue and cost, but the denominator changes. The formula:
Markup = (Revenue - Cost) / Cost × 100
Same example: a $100 product with a $60 cost. The math: ($100 - $60) / $60 × 100 = 66.7%.
Cost sits at the bottom now. Markup measures profit as a share of what you spent, not what you earned. Where margin asks how much of each incoming dollar you kept, markup asks how much above cost you charged. A 66.7% markup means the price is 66.7% higher than the cost basis.
That shift in denominator is why the same $40 profit looks so different depending on which figure you use.
Both terms measure profitability, but they start from different places in the math.
Margin is calculated as a percentage of the selling price. Markup is calculated as a percentage of the cost. Same dollar profit, two completely different percentages, and that gap is where founders consistently make mistakes.
Here is the clearest way to see it:
The formulas behind those numbers:
Because markup divides by a smaller number (cost), it always produces a higher percentage than margin for the same transaction. A 40% margin is not the same as a 40% markup, and confusing the two can mean you are pricing products below what you actually need to stay solvent.
Margin works backward from revenue, which is why it maps cleanly onto your income statement and the gross margin line your investors will examine closely. Markup works forward from cost, which makes it useful for setting prices at the point of purchase or in wholesale contexts.
Neither is wrong. They answer different questions: margin tells you what percentage of each dollar of revenue you kept, while markup tells you how much you added on top of what you paid.
Two formulas do all the heavy lifting here. Knowing them cold means you can price on the fly without second-guessing yourself.
Margin = (Selling Price - Cost) / Selling Price
A $100 product that costs you $60 to make carries a 40% gross margin: ($100 - $60) / $100 = 0.40.
Markup = (Selling Price - Cost) / Cost
That same product carries a 67% markup: ($100 - $60) / $60 = 0.667.
Same dollars of profit, two very different percentages because the denominator flips between the two calculations.
The gap between the two numbers widens as your margins get thinner, which is exactly why mixing them up in a pricing conversation can mean quoting a deal that loses money.
The quickest way to move between margin and markup without a formula is a reference table. Here are the most common conversions founders and operators actually use:
| Margin % | Markup % |
|---|---|
| 10% | 11.1% |
| 20% | 25.0% |
| 25% | 33.3% |
| 30% | 42.9% |
| 40% | 66.7% |
| 50% | 100.0% |
A few patterns worth noticing as you read this table:
If you are working backward from a specific target, the most common scenarios founders ask about are 30% margin to markup (42.9%) and 25% markup to margin (20%). Bookmark those two, and you will cover most real-world pricing conversations.
Three numbers that show how this plays out in practice:
In each case, the markup is higher than the margin. That gap is where pricing mistakes happen.
Markup works better when you're thinking from cost outward: you know what something costs, you want to apply a standard multiplier, and you're pricing on the fly. Retail, wholesale, and manufacturing businesses often default to markup for this reason.
Margin is the right lens when you're working backward from revenue: tracking gross profit, modeling unit economics, or reporting to investors. Most financial statements, SaaS benchmarks, and fundraising conversations run on margin.
A practical rule: use markup to set prices, use margin to measure results.
Confusing margin and markup costs founders real money, and the errors tend to cluster around a few predictable patterns. Strategic CFO on markup vs. margin pricing covers why consistent use of one metric matters across your product lines.
The root cause is almost always that the two numbers feel interchangeable until they aren't. At low price points the gap is small enough to ignore. At scale, or when a single pricing decision touches thousands of units, the compounding difference between a 50% markup (33.3% margin) and a genuine 50% margin becomes a material line on your P&L.
Four columns cover everything you need: cost, selling price, margin, and markup. Here is a simple setup that auto-calculates both figures from a single cost and price input.
Start with these column headers in row 1: Cost (A), Selling Price (B), Gross Profit (C), Margin % (D), Markup % (E).
=B2-A2=C2/B2=C2/A2Format columns D and E as percentages. Every row you add will auto-calculate both metrics instantly.
Add two utility cells anywhere on the sheet:
=D2/(1-D2)=E2/(1+E2)These let you toggle between the two without rebuilding anything. If a vendor quotes you a 30% markup, paste that into the markup cell and the margin cell will show you the real 23.1% margin automatically.
The math is simple, but having it live in a spreadsheet removes the mental overhead so you stop defaulting to whichever number feels right in the moment.
Margins vary widely by industry, so knowing where your business sits helps you price with confidence and avoid guessing. NYU Stern's margin data by sector is a reliable reference for checking where your industry typically lands.
Here are common gross margin benchmarks across industries, with the implied markup at each level:
The same product with a 50% markup yields a 33% margin. Whether that's healthy or thin depends entirely on your sector.
Use these ranges as a gut-check when setting prices. If your margin falls well below your industry's floor, your markup formula may be the culprit.
Knowing the right formulas is half the problem. Having accurate, current numbers to apply them is the other half.
Puzzle automates up to 98% of transaction categorization and cuts reconciliation time by up to 96% (2 hours down to 5 minutes), so your P&L updates daily. Your gross margin is never three weeks stale when a burn rate or pricing call needs it.
Puzzle also maintains simultaneous cash and accrual books, which matters because investors want accrual-basis gross margin, and having both versions live removes ambiguity during burn rate and runway conversations.
For accounting firms supporting startup clients, Puzzle's AI agents cut month-end close time by up to 50%, with accurate client financials ready by the 4th business day of each month.
Confusing margin and markup feels minor until it isn't. A 40% markup is not a 40% margin, and at scale that gap shows up as a real number on your P&L. Now that you know the formulas, the conversion table, and when each metric applies, you can price and report with confidence. Book a demo to see how Puzzle keeps your gross margin accurate and up to date so the right number is always there when you need it.
Both use the same numerator (selling price minus cost), but the denominator is what separates them: margin divides by selling price, markup divides by cost. On a $100 product with a $60 cost, that produces a 40% margin versus a 66.7% markup. Same $40 profit, two very different percentages that will not behave interchangeably in pricing or investor conversations.
A 40% margin requires a 66.7% markup, not a 40% markup. Applying a 40% markup when your target is a 40% margin leaves you with only 28.6% margin instead, a gap that compounds fast across thousands of units. Use the conversion formula: markup equals margin divided by (1 minus margin), or keep the markup vs. margin chart in this post bookmarked for quick reference.
Use markup to set prices when you know your costs and need a quick multiplier at the point of purchase. Use margin to measure results: for your income statement, unit economics modeling, and any conversation with investors, who read financials in margin terms, not markup. A practical rule: markup sets the price, margin tells you whether the business is working.
Four columns cover everything: Cost (A), Selling Price (B), Gross Profit (C = B minus A), Margin % (D = C divided by B), Markup % (E = C divided by A). Format D and E as percentages and every row auto-calculates both figures. Add two utility cells for conversion: margin to markup uses the formula D divided by (1 minus D), and markup to margin uses E divided by (1 plus E). That covers the full markup vs. margin formula calculator workflow without any manual math.
Yes. Puzzle automates up to 98% of transaction categorization and cuts reconciliation time by up to 96%, so your P&L updates daily instead of sitting three weeks stale when a pricing decision needs it. Puzzle also maintains simultaneous cash and accrual books, which means your accrual-basis gross margin (the number investors will ask for) is always current alongside your daily cash position.





