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.

Download Excel with a Microsoft 365 subscription or try Excel, free. Create excel spreadsheets & pivot tables, share XLS files and organize your data. Learn how Microsoft uses ads to create a more customized online experience tailored for you. Microsoft Office Specialist Excel certification. Our cutting-edge Excel certification program gives testing candidates practical, performance-based scenarios to gauge their real-world capabilities with project and standards-based outcome testing.

When you buy Excel 2019 as part of Office Home & Student 2019, you only have to pay $149.99. This includes a one-time purchase for 1 PC or Mac of the classic 2019 versions of Word, Excel, and PowerPoint. You can also buy Excel alone for almost the same price. You have to search for it on the Microsoft Store since it’s not publicly advertised.

Table of Contents

• Excel Formula to Add Percentage Markup to a List of Products

What is Markup?

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

Again, we also calculate the Profit Margin in the same way. I mean Gross Profit Margin is also the difference between the Selling Price and Wholesale or Making Cost of the product.

But we calculate Markup % and Profit Margin % in different ways.

Here is the overall picture of these two concepts.

You see that to get the Markup %, we divide the Profit Margin (= Selling Price – Unit Cost) by the Cost Price. And to calculate the Profit Margin %, we divide the Profit Margin (= Selling Price – Unit Cost) by the Selling Price.

Adding Percentage Markup to the Cost Price (Example)

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

= $35

Now, what is your Profit Margin and Profit Margin %?

Profit Margin = Selling Price – Unit Cost = $35 – $25 = $10

Profit Margin % = Profit Margin / Selling Price = $10 / $35 =0.2857 = 0.2857 x 100% = 28.57%

Download Excel Calculator

Please download at first the Excel calculator that I have used to write this article.

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 30%) and on another occasion, you may offer a different Markup % (say 40%). 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 calculated the Selling Prices of these products for different Markup Percentages (30%, 40%, 50%, 60%).

We have also calculated the Profit Margin for those Selling Prices.

Excel formulas used to get the results

We have made just two Excel formulas to get the results.

1) In cell D6, I have used this Excel formula: =$C6*(1+D$5).

You see that this formula has mixed cell references. Column C and Row 5 is made 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 reference $5 will not change.

2) In the cell H6, I have entered this formula: =D6-$C6

This formula has one mixed reference: $C6. As the column C is absolute, when we shall apply the formula on the right cells, the $C reference will not change.

Calculating Selling Price, Cost Price, Markup % and Profit Margin % from One Another

1) Calculate Selling Price and Profit Margin % from the Cost Price and Markup %

In this calculation, Cost Price and Markup % are given, we calculate the Selling Price and the Profit Margin % from those data.

Here is the procedure:

2) Calculate Cost Price and Profit Margin% from Markup % and Selling Price.

In this calculation, Selling Price and Markup % are given. We calculate the Cost Price and Profit Margin% from them.

3) Calculate Cost Price and Markup % from the Profit Margin % and the Selling Price.

In this calculation, Profit Margin % and Selling Price are given. We will calculate the Cost Price and Markup % from them.

Markup % vs. Gross Profit Margin %

From our above discussion, it is clear now the difference between the Markup % and Gross Profit Margin %.

Using Markup %, we determine the Selling Price of a product based on the Cost Price.

We get Profit Margin % dividing the Profit Margin by the Selling Price.

Markup % varies from industry to industry.

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 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. If you have any comments, please let me know in the comment box.

Thanks for being with my blog.

Happy Excelling!

In this how-to article, you will learn how you can build your very own Cost Calculator. Having the ability to calculate the cost is important in educating consumers and potential customers.

Gather the Tools

What you will need to build your own Cost Calculator:

Microsoft Excel – Excel will allow you to add the input and output labels and formulas for your calculator.

LeadDoubler – LeadDoubler is a web-based software that will allow you to turn the raw .xls (Excel file) into a beautiful and fully-functional online calculator.

Ready? Let’s go!

The process:

• Step 1: Create Excel Document
• Step 2: Launch LeadDoubler and Choose a Template
• Step 3: Edit Page and Publish

Step 1: Create Excel Document

Our example Cost Calculator will be “How much do you spend on coffee?”

I saw this on a USA Today Article and thought it would be a great example to use for this how-to article.

Let’s start by opening Microsoft Excel and creating a new worksheet.

First, we have the Inputs, the Labels and the Values for our Excel file. Column A will have our labels, Column B our default values, and Column C will define the range of the values (and types of input).

Next, we add the label “calculate” to separate the inputs and outputs. Anything listed after the “calculate” cell will be considered outputs.

Excel Cost Estimate Template

In Column B, below “Calculate” label, we can add our formulas. In this Coffee Cost Calculator we will just do a basic multiplication of the input values.

Now we are ready to upload our Excel Sheet in Step 2.

Step 2: Launch LeadDoubler and Choose a Template

• Go to LeadDoubler.com
• Click the green “Signup” button and Register for a free account.

Now, once you are in your dashboard, click the green “New Project” button on the right.

You are now in the template gallery, click the “simple white landing page”.

Now, you are at the template preview page, click the “choose” link on the right to get started editing your landing page and calculator.

This brings us to Step 3.

Step 3: Edit Page and Publish

Excel Cost Estimate Template

Now, click “Edit landing page” on the top right

Select “Upload Spreadsheet to change form” and upload the Excel document you created earlier.

Next, we can click “preview” to test and see how your calculator will work and see how it will look before its live.

Now our Calculator is active and ready to calculate.

Free Excel Cost Analysis Template

Now, when you are ready to publish, click “publish” in the upper right corner of the dashboard and it will bring you to the publish page.

From here you can create your landing page URL or connect it to your own existing domain. The choice is yours.

Excel Cost Formula

Well, Congratulations you now have your very own Cost Calculator!