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.

## 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 Price** – **Unit Cost)** by the **Cost Price**, multiplied by 100.

**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%).

### 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)`

**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.

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)`

- 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)`

- 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

**How to Calculate Sales Growth Percentage in Excel****Subtract a Percentage in Excel (Easy Way)****How to Calculate Percentage of Sales in Excel****How to Calculate Growth Percentage Formula in Excel****How to Calculate Variance Percentage in Excel****How to find percentage between two numbers in Excel****How do you Calculate Percentage Increase or Decrease in Excel****How to Calculate Cumulative Percentage in Excel****How to calculate salary increase percentage in Excel [Free Template]****Calculate Excel percentage difference between two numbers (using formula)**

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