Profit Margin Calculator Gross margin %, with profit and markup from cost and price

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

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

Margin = (price − cost) ÷ price

Profit margin
—
share of selling price
Profit
—
Markup
—

Do this in Excel or Google Sheets

With cost in A1 and selling price in B1:

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

Pricing and margin models are bread-and-butter Excel work. My course shows you how to build them cleanly.

Learn Excel with my course →

What profit margin means

Profit margin is the profit expressed as a percentage of the selling price. If something sells for 100 and cost 40, the 60 of profit is a 60% margin. Because it's measured against the price the customer pays, margin can never exceed 100% — a useful sanity check, and the key difference from markup.

Margin vs markup

Frequently asked questions

Can margin be more than 100%?

No. Since margin is profit divided by selling price, it approaches but never reaches 100% (that would mean zero cost). Markup, however, can exceed 100%.

What does a negative margin mean?

You're selling below cost, so each sale loses money. The calculator flags this in red.

Is this gross or net margin?

This is gross margin on a single item — price minus direct cost. Net margin would also subtract overheads, tax and other expenses.