Margin vs Markup: Formulas and a Worked Pricing Example

Four paper card tags

Margin and markup compare the same price difference with different bases. Margin divides the difference by selling price; markup divides it by cost. Confusing them can produce a price different from the one you intended.

The formulas below are a calculation guide, not an interactive calculator or a recommendation for your business’s pricing.

Define the inputs

Let selling price be the amount received for the item on a consistent tax basis, and cost be the cost figure you have chosen for this calculation.

Use the same currency and tax treatment throughout. Record what the cost includes. A calculation using only material cost does not tell you the profit remaining after every business expense.

Business Queensland’s financial ratio guidance explains gross profit in relation to sales and cost of goods sold.

Use the formulas

Price difference = Selling price − Cost

Margin percentage = Price difference ÷ Selling price × 100

Markup percentage = Price difference ÷ Cost × 100

Margin requires a nonzero selling price. Markup requires a nonzero cost. If the relevant denominator is zero, report the calculation as undefined rather than displaying a misleading percentage.

Work through an example

Suppose an illustrative item sells for €100 and its defined cost is €60.

The difference is €40.

  • Margin: €40 ÷ €100 × 100 = 40%.
  • Markup: €40 ÷ €60 × 100 ≈ 66.67%.

The cash difference is identical. The percentage changes because the denominator changes.

A 40% markup on €60 would instead produce a price of €84. That is not the same as a 40% margin.

Calculate a price from a target percentage

For a target markup expressed as a decimal:

Price = Cost × (1 + Markup)

For a target margin expressed as a decimal below 1:

Price = Cost ÷ (1 − Margin)

Using €60 cost and 40% target margin gives €60 ÷ 0.60 = €100.

A target of 100% margin cannot produce a finite positive price with a positive cost under this formula.

Put the calculation into a worksheet

Use columns for item, cost definition, cost, selling price, difference, margin, and markup.

If cost is in B2 and price is in C2:

  • Difference: =C2-B2
  • Margin: =IF(C2=0,"",(C2-B2)/C2)
  • Markup: =IF(B2=0,"",(C2-B2)/B2)

Format the last two cells as percentages. Do not multiply by 100 as well if percentage formatting already performs the display conversion. Formula separators may vary by spreadsheet locale.

Interpret the result carefully

This simplified model excludes anything not included in your cost definition. Discounts, returns, payment fees, delivery, overhead, and taxes may require additional treatment.

Label the output precisely and have accounting classifications checked where they matter. The useful result is a transparent calculation whose inputs you understand, not a percentage presented as complete proof of profitability.