How Do You Calculate Markup Percentage For Pricing

The same 40 of profit on a 100 sale can be called a 66.7 percent markup or a 40 percent margin, and both are correct. That single fact causes more pricing mistakes than any formula error. Markup and margin use the same profit but divide it by different bases, so they never match on a profitable sale. This guide clears up which is which, then shows how to calculate markup, and it supports the Food Cost Percentage Calculator because restaurant pricing often needs food cost, margin, and markup side by side.

Markup Vs Margin: Which Number Are You Looking At?

Markup and margin answer different pricing questions. Markup asks how much profit was added relative to cost. Margin asks how much of the sale price remains after cost.

Metric	Formula	Denominator
Markup percentage	(selling price − cost) ÷ cost × 100	Cost
Margin percentage	(selling price − cost) ÷ selling price × 100	Selling price

The base is the reason markup is higher than margin when the item is profitable. A product with cost of 60 and sale price of 100 has a 66.7 percent markup and a 40 percent margin. Both are right; they answer different questions. Before you trust any pricing number, confirm which base it uses, keep discounts in mind so a good markup on paper is not undone at the till, and pair the rate with market sense rather than reading it alone.

What Is The Markup Percentage Formula?

Markup rate compares the profit added to an item with that item’s cost. OpenStax explains gross profit as sales minus cost of goods sold, and markup uses that difference against cost rather than sales. The result shows how much the business added on top of cost.

Formula: markup rate = ((selling price − cost) ÷ cost) × 100.

If cost is zero, markup rate is undefined because the formula cannot divide by zero. If selling price is below cost, markup is negative. A negative markup means the item sold for less than its cost before considering any other operating expense.

How Do You Calculate Markup Step By Step?

Start with the cost that belongs to the product or service. For a retail item, that might be purchase cost. For a restaurant item, that might be ingredient cost. For a job, it might include materials and direct labour if your pricing policy uses both.

1. Record the selling price.
2. Record the cost.
3. Subtract cost from selling price.
4. Divide the result by cost.
5. Multiply by 100.
6. Label the result as markup rate, not margin.

Do not use markup alone for final pricing if overhead, labour, tax, discounts, and market demand matter. Markup gives a clear cost-based view, but price decisions need more context.

How Can Excel Calculate Markup Percentage?

Excel can work out markup rate with =(B2-A2)/A2 when cost is in A2 and selling price is in B2. Format the result cell as Percentage. Microsoft’s Excel guidance explains that a rate result starts as a decimal before percent formatting displays it as a percent.

If a spreadsheet also includes margin, give each column a clear label. Use =(B2-A2)/B2 for margin when selling price is in B2. The formulas look similar, so a label error can cause pricing confusion.

Worked example. Cost = 60, selling price = 100.

Markup percentage = ((100 − 60) ÷ 60) × 100. 100 − 60 = 40. 40 ÷ 60 = 0.6667. 0.6667 × 100 = 66.67. Result: the markup rate is 66.7%, rounded to one decimal place.

Margin comparison: ((100 − 60) ÷ 100) × 100 = 40. The margin rate is 40.0%. The same sale has a 66.7% markup and a 40.0% margin.

When Should A Business Use Markup?

Use markup when pricing starts with cost and adds a planned rate on top. Retailers, contractors, and restaurants often use markup as one input when setting prices. It can help turn item costs into sale prices quickly.

Use margin when reviewing profit as a share of sales. Accountants, managers, and lenders often prefer margin because it shows how much of sales remains after cost. A good pricing sheet can show both, as long as the two columns are clearly named. See the Finance Calculators hub for related tools.

Sources And Notes For Markup Percentage

• OpenStax, Principles of Finance, gross profit and gross margin context
• OpenStax, Introduction to Business, profit margin and return on sales context
• Microsoft Support, Calculate percentages in Excel

This guide is for educational estimates only and is not accounting, legal, tax, or financial advice. Ask a qualified expert before making business decisions.