Excel Formula to Add Percentage Markup (3 Suitable Examples)

In this tutorial, I will show several ways of using the Excel formula to add percentage markup to the cost price of a product. Adding Markup % to the cost price will give you the selling price of the product.

The following image shows an overview of using the Excel formula to add Markup %. You can use it as a calculator too.

Examples of Excel formula to add markup percentage in different ways.


Download Practice Workbook

Please download the following practice workbook that I have used to write this article. You can also use the last worksheet as a calculator.


Basic Formula to Add Percentage Markup in Excel

Markup is the difference between the Selling Price and the Wholesale or Making Cost of a product.

You will get the Markup % by dividing the (Selling PriceUnit Cost) by the Cost Price, multiplied by 100.

Basic markup % formula

An Example to Add Percentage Markup to Cost Price:

For example, your wholesale price (Cost Price) of a product is $25. Now you want to add a 40% Markup to the wholesale price of the product. What will be your selling price?

Your Selling Price will be:

= Wholesale Price x (1+Markup %)

= $25 x (1 + 40%)

= $25 x 1.40


3 Examples of Excel Formula to Add Percentage Markup to a List of Products

Suppose you have a list of products, and you want to add different Markup % to those products. On one occasion, you can offer your customers one Markup % (say 10%) and on another occasion, you may offer a different Markup % (say 20%). All these pricing can be done in one Excel sheet.

You are seeing an Excel worksheet in the following image. A list of gardening-related tools. Every product has a Wholesale Cost. We have to calculate the Selling Prices of these products for different Markup Percentages (10%, 15%, 20%, 25%).

Sample Data with wholesale prices and markup %


1. Use a Customized Excel Formula to Add 10, 15, 20, or 25% Markup

We have made just an Excel formula for adding Percentage Markup. Apply the following steps to use it.

📌 Steps:

  • In cell D7, I have used the following Excel formula:
  =$C7*(1+D$6)

Using a Customized Excel Formula to Add 10, 15, 20, or 25% Markup

Quick Notes:

  • You see that this formula has mixed cell references. Column C and Row 6 are made of absolute references.
  • We know when we go down or up, row references change. When we go left or right, column references change.
  • For the above formula, when we will go right, $C will not change and when we shall copy the formula down, the row references $6 will not change.
  • Now, pull the Fill Handle icon first rightwards and second downwards.

copying a formula with fill handle tool

We can see the result is showing in the covered cells. We can also drag the Fill Handle icon in the opposite order and will get the same result.


2. Apply Excel SUM Function to Add Percentage Markup

We can use the Excel SUM function that simplifies the calculation of adding percentage markup in Excel.

📌 Steps:

  • Put the formula below on Cell D7.
=SUM($C7,$C7*D$6)

Formula based on SUM function to add percentage markup

  • Then, drag the Fill Handle icon both rightward and downward one by one.

Note:

Like, the previously shown methods we applied mixed reference in the formula. Here, Column C and Row 6 are fixed. So, we used $C and $6 in the formula.


3. Use PRODUCT Function

The PRODUCT function multiplies all numbers given as arguments. In this section, we will use the PRODUCT function that adds percentage markup easily with the result.

📌 Steps:

  • Again, go to Cell D7 and paste the following formula.
=PRODUCT($C7,1+D$6)

Get markup % applying PRODUCT function

  • Similarly, pull the Fill Handle icon in two directions shown in the previous methods.

Like, the previous methods we’ve applied mixed references in the formulas in a similar way.


Conclusion

Checking out your industry Markup % and determining the Selling Price of your product is important for becoming successful in your business. Being in the Shoe industry and accepting the Markup % of the Grocery industry will lead you to financial disaster.

So, these are my Excel formulas to add percentage markup to the cost price to get the selling price of a product. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.

Thanks for being with my blog. Happy Excelling!


Further Readings

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

1 Comment
  1. Hello, thank you fr the post, really helpful insights, but what if your product cost varies, for instance when importing, is there any way to create a formula to determine the margin when there is an increase or decrease? I’m struggling to get that one right

Leave a reply

ExcelDemy
Logo