How to Calculate Markup in Excel

To use Excel 2013 to compute markup as a percentage of wholesale cost, create a formula that divides the markup amount by the cost.

...
Markup Percent Calculations
credit: Image courtesy of Microsoft

Computing Markup Percent

Step

Enter the wholesale cost and retail price for each item into a worksheet.

...
Enter Cost and Price
credit: Microsoft
...
Markup Percent Formula
credit: Microsoft

Step

Compute the markup percent by writing a formula that divides the difference between price and cost by the cost. This can be visualized as (Price-Cost)/Cost. For example, if cost is $10 and price is $12, then the markup amount is $2 ($12-$10) and the markup percent is 20 percent ($2/$10).

Step

In Excel, assuming the cost for the first item is stored in C7, the price is stored in D7, and the markup percent needs to be computed in cell E7, enter =(D7-C7)/C7 into cell E7.

Step

Press the Enter key on your keyboard and confirm the formula returns the expected markup percent.

...
Format Cells
credit: Microsoft

Step

If the markup percent cell is not formatted as a percentage, the displayed value may be 0.2 instead of the desired 20 percent. If this is the case, change the cell format by selecting the formula cell and then the Home > Format > Format Cells icon to open the Format Cells dialog box. Change the formatting to Percentage and specify the number of decimals to display.

...
Markup Percent
credit: Microsoft

Step

Fill the markup percent formula down through the range by copying the formula cell and pasting it into the remaining cells in the range. Excel updates the markup percentage when the cost or price values change.

Computing Retail Sales Price

Step

If you know the cost and markup percentage, you can write an Excel formula that computes the retail sales price. Enter the cost and markup percent for each item into a worksheet.

...
Cost and Markup Percent
credit: Microsoft
...
Price Formula
credit: Image courtesy of Microsoft

Step

The price is equal to the cost plus the markup amount. The markup amount is computed by applying the markup percent to the cost. For example, if the cost is $10 and the markup is 20 percent, the sales price of $12 is determined by adding the cost of $10 to the markup amount of $2 ($1020%). Assuming the cost is stored in cell C7, the markup percent is stored in D7 and the price will be computed in E7, enter **=C7+(C7D7)** into E7.

...
Retail Prices
credit: Image courtesy of Microsoft

Step

Fill the formula down and confirm that Excel has computed the expected sales prices.