Excel Markup Formula from Cost: Easy Steps

Formulas & functions · Updated November 22, 2026

The simplest Excel markup formula from cost is =Selling Price / Cost - 1, or equivalently =(Selling Price - Cost) / Cost. For example, if you bought an item for $50 and sold it for $75, the markup is =75/50-1, which returns 0.50, or 50%.

Markup vs. Margin: The Core Distinction

Markup and margin are frequently confused, but they answer different questions. Markup expresses the profit as a percentage of the cost (what you paid). Margin expresses the profit as a percentage of the selling price (what the customer pays).

Using the $50 cost and $75 selling price example:

  • Markup = (75 – 50) / 50 = 0.50 → 50%
  • Margin = (75 – 50) / 75 = 0.3333 → 33.3%

This difference matters in pricing decisions. A 50% markup does not mean you keep half of every sale; you keep a third. If you set prices by markup but track profitability by margin, your numbers will look inconsistent. Many small businesses mistakenly quote a “50% margin” when they actually mean a 50% markup, which under-prices their goods.

The Basic Formula in Excel

Assume your cost is in cell A2 and your selling price is in cell B2. To calculate the markup percentage, enter this in cell C2:

=(B2-A2)/A2

Format cell C2 as a percentage (Home > Number Format > Percentage). The result shows the markup as a decimal converted to a percent. For cost $50 in A2 and selling price $75 in B2, the formula returns 0.50, displayed as 50%.

If you prefer to see the markup as a decimal multiplier (e.g., 1.50 meaning “sell at 150% of cost”), use:

=B2/A2

That returns 1.50 for the same numbers. The first formula is more common because it directly gives the percentage increase over cost.

Calculating Selling Price from a Desired Markup

Often you know your cost and the markup you want, and you need the selling price. If cost is in A2 and the desired markup (as a percentage, e.g., 40%) is in B2, the selling price formula is:

=A2*(1+B2)

With A2 = 50 and B2 = 0.40, the result is 70. That means a 40% markup on a $50 item gives a $70 selling price. If you type 40% directly into B2, Excel treats it as 0.40, so the formula works without conversion.

For a markup multiplier (like 1.40), simply use =A2*B2 where B2 contains 1.40.

Handling Multiple Items with a Table

For a list of products, set up columns: Item (A), Cost (B), Selling Price (C), and Markup (D). In D2, enter:

=(C2-B2)/B2

Then drag the fill handle down from D2 to copy the formula to other rows. Excel adjusts the row references automatically. If you have hundreds of rows, double-click the fill handle to fill the entire column instantly.

If some cells are blank or contain text, the formula will return a #VALUE! error. To avoid this, you can wrap the formula in an IFERROR:

=IFERROR((C2-B2)/B2,"")

This shows a blank cell instead of an error when data is missing.

Common Mistakes and How to Avoid Them

The most frequent error is dividing by the selling price instead of the cost. That gives you margin, not markup. Always divide by the cost (the denominator). Another mistake is mixing up percentage formatting: if you enter 50 in a cell expecting it to mean 50%, Excel sees it as 5000%. Always type 0.5 or 50% (with the percent sign) in the cell, or use the percentage format on the result.

A third issue arises when costs change over time. If you update the cost column but forget to update the selling price, your markup will be wrong. Consider using a separate column for “updated cost” or linking the selling price to cost plus a fixed markup using =B2*(1+$E$1) where E1 holds your standard markup percentage. The dollar signs lock the reference so you can change one cell and update all prices.

Using Excel’s Built-in Percentage Tools

Excel does not have a dedicated “markup” function, but you can use the percentage number format and the basic arithmetic above. For a quick calculation without formulas, you can use Paste Special:

  1. Enter your cost values in column A.
  2. Type 1.5 (for a 50% markup) in an empty cell and copy it.
  3. Select the cost cells, right-click, choose Paste Special, select “Multiply,” and click OK.

This replaces each cost with cost × 1.5, giving you the selling price. This is useful for one-off adjustments but overwrites your original costs, so save a backup first. On a Mac, the same Paste Special menu is under Edit > Paste Special.

Frequently Asked Questions

What is the difference between markup and margin in Excel?
Markup divides profit by cost; margin divides profit by selling price. In Excel, markup formula is =(Selling Price - Cost)/Cost, while margin is =(Selling Price - Cost)/Selling Price. For a $50 cost and $75 price, markup is 50% and margin is 33.3%.

How do I add a markup percentage to a cost in Excel?
Multiply the cost by (1 + markup percentage). If cost is in A1 and markup is 25%, use =A1*1.25 or =A1*(1+0.25). This gives the selling price.

Can I calculate markup if I only know cost and margin?
Yes. If you know margin (as a decimal), markup = margin / (1 – margin). For example, a 30% margin (0.30) gives markup = 0.30 / 0.70 = 0.4286, or 42.86%. In Excel, with margin in B1, use =B1/(1-B1).

Why does my markup formula show a decimal like 0.5 instead of 50%?
Because the cell is formatted as a number, not a percentage. Select the cell, go to Home > Number Format, and choose “Percentage.” Alternatively, multiply the formula by 100 and format as a number.

What if my cost includes tax or shipping?
Include all direct costs in the cost cell. If tax and shipping vary per item, add them in separate columns and sum them before calculating markup. For example, use =((C2+D2)-B2)/B2 where B2 is base cost and C2 and D2 are tax and shipping.

Practical Example: A Small Retail Pricing Sheet

Suppose you sell three products with the following costs and desired markups:

  • Product A: cost $10, desired markup 50% → selling price = 10 × 1.5 = $15
  • Product B: cost $25, desired markup 30% → selling price = 25 × 1.3 = $32.50
  • Product C: cost $8, desired markup 75% → selling price = 8 × 1.75 = $14

In Excel, put costs in A2:A4 and desired markups (as decimals) in B2:B4. In C2, enter =A2*(1+B2) and copy down. The results match the manual calculations. You can then check your margin with =(C2-A2)/C2 to see what percentage of each sale is profit.

For a more advanced setup, use a named range for the markup cell (e.g., name E1 as “Markup”) and write =A2*(1+Markup). This makes the formula readable and easy to update.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.