How to calculate markup in Excel and Google Sheets

Excel & Google Sheets

=(B2-A2)/A2

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

=(B2-A2)/A2→0.25

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1Create two columns: Cost (A) and Selling Price (B). Enter your values in rows 2 onward.
2In the Markup % column, enter =(B2-A2)/A2. This divides the profit (Selling Price minus Cost) by the Cost.
3Format the result cell as Percentage to display the markup as a percentage (e.g., 0.25 becomes 25%).

To calculate the selling price from a cost and desired markup, use =A2*(1+markup_rate), e.g., =A2*1.30 for a 30% markup.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Markup is calculated on cost; margin is calculated on the selling price. A 25% markup equals a 20% margin.

Multiply the cost by (1 + markup rate): =A2*(1+0.30) for a 30% markup.

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026