Markup calculator

Enter cost and selling price to see your markup, and the same sale as a margin.

Enter cost and selling price to see your markup.

Everything is worked out in your browser, and nothing you type is sent anywhere.

What the result means

Markup is what you add on top of cost, measured against the cost. Margin is the same profit measured against the price, so whenever there's a profit, markup is the bigger number. Mixing them up is how prices end up lower than planned: a 50% markup is only a 33% margin.

The formula

Markup = (price − cost) ÷ cost × 100

A worked example

An item costs 40.00 and sells for 65.00, so each sale makes 25.00. Against the cost that is a markup of 62.50%; against the price it is a margin of 38.46%.

How gross margin works in Google Sheets

Track your Shopify sales in Google Sheets, refreshed on a schedule.

Start free trial

30 days of Plus, free from sign-up. No card needed.

Sign in with Google or a work or school Microsoft account.

Add to Google Sheets

Prefer to stay in Google Sheets? Add the add-on and start from the Extensions menu.