How to add 25 percent to a price in Excel

Microsoft Excel provides numerous mathematical functions that save time and improve accuracy in data entry. Percentage markups are used in retail, government and business environments to calculate the percent of a value that will be added to that value. Excel allows you to calculate percent markup values and then add them to your data.

Percentage Markup

1. Percentage markups are important in a variety of settings because they calculate the percent of a value that can be added to the original value. In a retail environment, an item that is purchased for $5.00 with a percentage markup of 25 percent should be sold for $6.25. Sales tax is calculated in a similar way. You can input your data set into Excel, then add your own percentage markup values in your spreadsheet.

Product Function

1. Excel provides the PRODUCT() function to calculate the original value by the percentage markup. Place your original value or cost into column A and label it with a description. Input the percentage markup into the adjacent column B and label it as well. Input "=PRODUCT(A2,B2)" into column C (without quotation marks) and label the calculated column. The calculated column expresses the amount that you can add to the original value for your final cost.

Alternate Product Function

1. Excel provides another option for using the PRODUCT() function. Instead of calculating the original value by a value in the next cell, you can also multiply the original value by a set number. For example, if you have input the original values in column A, you can use "=PRODUCT(A2,0.25)" (without quotation marks) to multiply the original value by 25 percent. The "0.25" in the function represents the percentage markup.

Sum Function

1. After calculating percentage markups, you can use the SUM() function in Excel to add the markup values to the original value. For example, if your wholesale item costs $10 and the markup is 25 percent, the markup value is $2.50. That value doesn't explain how much the item should be sold for, however, so you need to use the SUM() function. In column D, input "=SUM(A2,C2)" (without the quotation marks) to calculate the final value. In this example, it would be $12.50.

In this tutorial, we’ll learn three different ways how to calculate percentage increase in Excel. All of them are correct and can be used interchangeably to get the same result.

Let’s start!

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=itJyrUn1Tl0&t=97s

Let’s say we need to increase these three values that appear in the column B by 10%, and we need the result to show in the column C.

First Way How to Calculate Percentage Increase in Excel

One way to do this is by following these steps:

Click on the cell C3, enter the equal sign, then enter B3 multiplied by 1.1. Excel will use this formula to increase the original value in the cell B3 by 10%.

If you need to increase the value by 20%, simply multiply B3 by 1.2.

Second Way How to Calculate Percentage Increase in Excel

And here’s the second way how to calculate percentage increase in Excel:

Go to the cell C4 and enter the equal sign again. Then click on the value you need to increase, in this case B4. We’ll multiply it by ‘110%’, which is exactly 100% as the full original price plus 10% of this value as the desired increase.

Note that this number must be stated in percent. If we want to increase the value by 30%, we’ll multiply it by ‘130%’ and that’s the trick!

Let’s move on!

Third Way Wow to Calculate Percentage Increase in Excel

Here comes the last, third way how to calculate percentage increase in Excel.

Select the cell C5 and type in the equal sign. Carry on by entering the reference to the price we want to increase, which is B5. And now we’ll add 10% of this value by typing in the plus sign, then ‘B5’, but the value from B5 must be multiplied by 0.1.

This formula adds 10% of the value to the value itself. That’s how we can calculate the increase of a value by 10%.

And that’s it for today!

We’ve covered three different ways how to calculate percentage increase of any number.

Which of the formulas mentioned in today’s tutorial do you like best?

Share your opinion with us – leave us a comment before you go! Our team will be happy to hear from you!

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!