To calculate markup in Excel, subtract cost from selling price, then divide the difference by cost: with cost in B2 and selling price in C2, enter =(C2-B2)/B2. Format the result as a percentage; for example, a $40 cost and a $60 selling price produce a 50% markup.
What markup means
Markup is the amount added to a product’s cost, expressed as a percentage of that cost. If an item costs $40 and sells for $60, the dollar markup is $20. Dividing $20 by the $40 cost gives 50%. Markup helps compare price increases across products with different costs and can help calculate a selling price from a cost and a target percentage.
Markup is not the same as the dollar difference or the selling price itself. In the example, $20 is the markup amount, $60 is the selling price, and 50% is the markup rate. Keeping those three quantities distinct makes both spreadsheet formulas and pricing conversations clearer.
Set up the basic Excel calculation
Create columns for the item, cost, selling price, markup amount, and markup percentage. For example, put the cost in B2 and the selling price in C2. The following formulas calculate the dollar markup and its percentage of cost:
- With cost in B2 and selling price in C2, enter
=C2-B2in D2. If B2 is 40 and C2 is 60, D2 returns 20. - With cost in B2 and selling price in C2, enter
=(C2-B2)/B2in E2. For the same values, E2 returns 0.5, or 50% when displayed as a percentage.
These formulas assume the selling price is greater than or equal to the cost and that the cost is not zero. In Excel for Microsoft 365 on Windows, select E2 and choose Home > Number > Percent Style to display the rate as a percentage. Increase or decrease the displayed decimal places using the decimal-place buttons in the same Number group. The underlying value remains 0.5; changing its display to 50.0% does not change the calculation.
Calculate the markup for a list of products
For a product list, put each item on a separate row and keep cost and selling price in consistent columns. If row 2 contains the first product, enter the dollar and percentage formulas in that row, then copy them down for the remaining products. In Excel, select the formula cells and drag the fill handle at the lower-right corner of the selection down the column. Excel adjusts relative references for each row: the next row uses its own cost and selling price.
For example, if the table has cost in B2:B10 and selling price in C2:C10, the formula in E2 calculates the percentage for the first product. Copying it into E3 changes the references to B3 and C3. Check that both columns use the same basis: a cost should not accidentally be compared with a price that includes a different quantity, currency, or unit. Add clear headings such as Cost per unit and Selling price per unit so the results are interpretable later.
To make the table easier to maintain, you can turn the range into an Excel table with Insert > Table. Tables provide filterable headings and typically copy a formula through a calculated column when you enter it in one row. This is useful when products are added, though it does not replace checking that new rows contain valid cost and price data.
Find a selling price from cost and target markup
Sometimes you know the cost and the markup rate you want, but not the selling price. The calculation is cost multiplied by one plus the markup rate. For example, a $40 cost with a 50% target markup gives a $60 selling price.
With cost in B2 and the target markup percentage in C2, enter =B2*(1+C2) in D2. If B2 is 40 and C2 is 50%, D2 returns 60. Format C2 as a percentage and enter 50% (or 0.5), not 50: the number 50 represents 5,000% when interpreted as a percentage in this calculation.
This arrangement is handy for a pricing sheet with one target rate applied to many products. Enter each product’s cost in column B and the target rate in column C, then copy the price formula down column D. If all products use the same target rate, you can keep that rate in one separate cell and use an absolute reference such as $F$1 in the formula, so the reference stays fixed when copied. Before relying on a calculated price, decide how prices should be rounded and whether the target applies to unit cost or to a broader cost that includes shipping, labor, or other expenses.
Markup versus gross margin
A common pricing mistake is to treat markup and gross margin as interchangeable. Markup divides the difference between selling price and cost by cost. Gross margin divides that same difference by selling price. They use different denominators, so the percentages differ even though they describe the same dollar difference.
With cost in B2 and selling price in C2, enter =(C2-B2)/C2 to calculate gross margin. If the cost is $40 and selling price is $60, the result is 33.33% (approximately), not 50%. In that example, the $20 difference is 50% of the cost but one-third of the selling price.
If you know the desired gross margin and need a selling price, the calculation differs from the markup-price formula. With cost in B2 and target gross margin in C2, enter =B2/(1-C2) in D2. A $40 cost and a 33.33% target margin return approximately $60. Do not use cost multiplied by one plus the margin rate; that method calculates a markup-based price and produces a different result. For ordinary positive costs, a target margin must be less than 100% for this formula to produce a finite price.
Choose what counts as cost
The arithmetic is straightforward, but the cost definition affects the usefulness of the answer. A product’s purchase price may not be its full cost to the business. Depending on the purpose of the spreadsheet, relevant costs might include freight, packaging, payment processing, or labor. Avoid adding costs twice if they are already included in the figure you use.
Decide whether the worksheet is meant to calculate a simple markup over purchase cost or to support a broader pricing estimate. Label the cost column accordingly, such as Landed cost per unit, and document what it includes. If different products have different additional costs, calculate a per-item total cost in its own column before using the markup formula. A consistent definition makes comparisons across products more meaningful.
Sales tax is usually treated separately from the item’s selling price when the goal is to measure markup on the product. If you include tax in the selling-price figure for one item but not another, the results will not be comparable. Likewise, discounts reduce the actual selling price: calculate markup using the price the customer actually pays when you want to evaluate the realized markup, rather than the original list price.
Handle rounding, missing values, and unusual results
Excel stores calculated values with more precision than the number format may show. A displayed price of $60.00 could have additional decimal places behind the scenes. Decide whether your business needs a rounded price and whether rounding should happen only for display or as part of the calculation. Rounding can slightly change the realized markup, so verify the rate after applying a price rule.
With a calculated selling price in D2, enter =ROUND(D2,2) in E2 to return a value rounded to two decimal places. For a selling price with a different rounding rule, change the number of digits or use a business-specific approach. Applying a currency format alone changes how a value appears; it does not round the stored value used in later formulas.
A zero cost makes the markup percentage formula undefined because it would divide by zero. A blank cost can also lead to confusing results, and a selling price below cost produces a negative markup, indicating a loss relative to the cost figure used. Do not silently treat these cases as ordinary percentages. Check the input data, decide how the workbook should flag exceptions, and consider leaving the result blank or showing a note rather than replacing every error with zero.
- If the markup seems unexpectedly low or negative, confirm that cost and selling price are in the intended columns and use the same currency and unit.
- If Excel displays a decimal such as 0.5, apply percentage formatting; if it displays 5000%, check whether 50 was entered instead of 50%.
- If a formula is treated as text, check that the cell is not formatted as Text and that the entry begins with an equals sign. Re-enter the formula after changing the format if needed.
- If a result shows a divide-by-zero error, check whether the cost cell is blank or zero before interpreting the percentage.
Frequently Asked Questions
What is the Excel formula for markup percentage?
With cost in B2 and selling price in C2, use =(C2-B2)/B2. Format the result as a percentage. The denominator is cost, which is what makes this a markup calculation rather than a margin calculation.
How do I calculate a 50% markup in Excel?
With cost in B2 and the target markup in C2, enter 50% in C2. With those cells as the inputs, =B2*(1+C2) returns a selling price equal to 1.5 times cost. A $40 cost therefore gives a $60 price.
Is 50% markup the same as 50% profit margin?
No. With a $40 cost and $60 selling price, markup is 50% of cost, while gross margin is about 33.33% of selling price. The terms use different denominators, so a rate given as markup cannot automatically be treated as the same margin rate.
How do I show markup as a percentage instead of a decimal?
Select the result cell and choose Home > Number > Percent Style. The value 0.5 will display as 50%. You can adjust the displayed decimal places for a more precise or simpler presentation.
Can markup be negative?
Yes. If the selling price is below the cost entered in the sheet, the calculation returns a negative percentage. It signals that the price is below that cost basis; check the inputs and cost definition before deciding what the result means for a particular business.
Related
- Attendance Roster Template in Excel: Setup and Tips
- Attendance Point Tracking Excel Template?
- Attendance Point System Template Excel: Build and Use
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Percentage Difference Formula: How to CalculateFor the percentage difference between two nonnegative values in Excel, use =ABS(B2-A2)/AVERAGE(A2,B2), then format the result as a…
- Paste Values in Excel: Keep Results, Remove FormulasTo get paste values in Excel, copy the cells, select where the results should go, then choose Home…
- Excel MAX Function for Dates: Find the Latest DateTo find the latest date in Excel, use =MAX(A2:A20), replacing the range with your date cells. Excel stores…
- Excel Formula for Years Between Dates: Exact or DecimalFor completed years between two dates in Microsoft Excel, enter a start date in A2 and an end…
- COUNTIF Examples: Formulas for Common Spreadsheet TasksUse Excel’s COUNTIF function to count cells in one range that meet one condition: =COUNTIF(range,criteria). For example, it…
- Excel FILTER and XLOOKUP: How to Use Them TogetherYes. In Excel for Microsoft 365, you can use XLOOKUP to find a value and FILTER to return…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.