Profit Calculator Profit, profit margin % and markup % from cost and price

Enter what an item costs you and what you sell it for. You'll get the profit, along with the margin and markup percentages. Works for any currency.

Free tutorialsFree Excel tips & tutorials at XLnCADstep-by-step guides by a 7× Microsoft Excel MVPVisit xlncad.com →
₹
₹

Profit = selling price − cost

Profit
—
per item
Profit margin
—
Markup
—

Do this in Excel or Google Sheets

With selling price in B1 and cost in A1:

ResultFormula
Profit=B1-A1
Profit margin=(B1-A1)/B1 (format as %)
Markup=(B1-A1)/A1 (format as %)

Building a pricing or profit sheet is one of the most useful things you can do in Excel. My course walks through it step by step.

Learn Excel with my course →

Profit, margin and markup — how they relate

Profit is the simplest of the three: it's what's left after you subtract cost from the selling price. The two percentages describe that same profit from different angles. Margin expresses profit as a share of the selling price, while markup expresses it as a share of the cost. That's why the markup percentage is always the larger of the two for a profitable item.

Worked example

Buy an item for 40 and sell it for 100. The profit is 60. As a margin that's 60 ÷ 100 = 60%; as a markup it's 60 ÷ 40 = 150%. Same profit, two very different-looking percentages — which is exactly why it pays to know which one someone means.

Frequently asked questions

What if I sell below cost?

The profit will be negative — a loss — and both percentages will be negative too. The calculator shows this in red.

Does the currency matter?

No. Enter both numbers in the same currency and the profit comes out in that currency; the percentages are currency-independent.

Is this before or after tax and overheads?

This is gross profit on a single item — selling price minus its direct cost. It doesn't include overheads, taxes or other operating expenses.