Markup Calculator Markup %, with profit and margin from cost and price

Enter what an item costs you and what you sell it for. You'll get the markup as a percentage of your cost, plus the profit and the profit margin. Works for any currency.

Excel courseLearn Excel from beginner to confident userthe Udemy course by Ajay Anand, 7× Microsoft Excel MVPView the course →
₹
₹

Markup = (price − cost) ÷ cost

Markup
—
added on top of cost
Profit
—
Profit margin
—

Do this in Excel or Google Sheets

With cost in A1 and selling price in B1:

ResultFormula
Markup=(B1-A1)/A1 (format as %)
Profit=B1-A1
Profit margin=(B1-A1)/B1 (format as %)
Price from cost & markup=A1*(1+markup)

Turning cost into price with the right markup is core retail maths — and a great Excel exercise. My course shows you how.

Learn Excel with my course →

What markup means

Markup is the amount you add on top of cost, expressed as a percentage of that cost. Buy for 40 and sell for 100 and you've added 60, which is a 150% markup. Retailers usually think in markup because they start from a known cost and mark it up to set a price.

Markup vs margin

Frequently asked questions

How do I set a price from a target markup?

Multiply the cost by one plus the markup. A 50% markup on a cost of 40 gives a price of 40 × 1.5 = 60.

Why is markup bigger than margin?

Because markup is measured against the smaller number (cost) while margin is measured against the larger number (price). Same profit, bigger denominator gives a smaller percentage.

What does a negative markup mean?

You're selling below cost — a loss. The calculator flags this in red.