# Excel Formula to Add Percentage Markup (3 Suitable Examples)

Here’s an overview of using an Excel formula to add Markup %.

## Basic Formula to Add a Percentage Markup in Excel

Markup is the difference between the Selling Price and the Wholesale or Production 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:

The wholesale price (Cost Price) of a product is \$25. The goal is to have a 40% Markup to the wholesale price of the product. What is the required selling price?

Selling Price = Wholesale Price x (1+Markup %) = \$25 x (1 + 40%) = \$25 x 1.40

## Excel Formula to Add Percentage Markup – 3 Examples

We have a list of products and want to add different Markup % to those products. Every product has a Wholesale Cost. We’ll calculate the Selling Prices of these products for different Markup Percentages (10%, 15%, 20%, 25%).

### Example 1 – Use a Customized Excel Formula to Add a Markup

Steps:

• In cell D7, use the following Excel formula:
Â  `=\$C7*(1+D\$6)`

Quick Notes:

• The formula has mixed cell references. Column C and Row 6Â are made of absolute references.
• When we go down or up, row references change. When we go left or right, column references change.
• When filling to the right, \$C will not change to keep the wholesale cost reference intact.
• When copying the formula down, the row references \$6 will not change to get the correct Markup % reference.
• Pull the Fill Handle icon to the right and then down.

### Example 2 – Apply the Excel SUM Function to Add a Percentage Markup

Steps:

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

• Drag the Fill Handle icon right, then down.

### Example 3 – Use the PRODUCT Function

The PRODUCT function multiplies all numbers given as arguments.

Steps:

• Go to Cell D7Â and paste the following formula.
`=PRODUCT(\$C7,1+D\$6)`

• Pull the Fill Handle icon to reach G12.

## Related Articles

<< Go Back to Add Percentage to a Number in Excel | Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

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

Advanced Excel Exercises with Solutions PDF