How to Add 10 Percent to a Number in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

We often need to add a certain percentage to a number. This article shows 2 quick and easy methods on how to add 10 percent to a number in excel. Adding or subtracting different percentages to a range of numbers is also possible by following those methods. The following picture gives an idea of how it is done.

Add 10 Percent to a Number in Excel


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Easy Ways to Add 10 Percent to a Number in Excel

I am going to show you two quick and easy ways to add 10 percent to a number. Assume, we have the following dataset containing a price list. We will use it to illustrate the methods.


1. Add 10 Percent to a Number Using Formula

You can add 10 percent to a number by using a few formulas. Follow the steps below to do that.

📌Steps

Formula 1:

  • Enter the following formula in cell D7:
=C7*(1+$C$4)
  • Then, use the fill handle tool to apply this formula to the cells below.
  • After that, the numbers will increase by 10 percent as shown below.

Add 10 percent to a number : Formula 1

Formula 2:

  • Alternatively, you can multiply the numbers by 110%. Because a number is 100% of itself.
  • Therefore, adding 10% of the number to itself means changing it to 110%.

  • Now, enter the following formula in cell D7:
=C7*$C$4
  • Then, it will give the same result as earlier.

Add 10% to a Number : Formula 2

Formula 3:

  • Besides, you can calculate the adding value first by entering the following formula in cell D7:
=C7*$C$4

  • After that, you can sum up the adding values with the original prices using the SUM function. Now, apply the following formula in cell E7 to do that.
=SUM(C7:D7)

Add 10 percent to a Number : Formula 3

Formula 4:

  • You can also multiply the prices by the decimal equivalent of the percentage. This will give the same result too.

Add 10 Percent to a Number : Formula 4

Add or Subtract Different Percentages:

  • Just change the percentage to add a different percentage to the prices. You can also put a negative sign before the percentage to subtract it from the prices.

Read More: How to Calculate Percentage of a Number in Excel (5 Easy Ways)


Similar Readings


2. Add 10 Percent to a Number Using Paste Special

Another quick and easy way to add 10 percent to a number is by the copy-paste tool. You can copy a number and multiply it with other numbers using Paste Special.

Follow the steps below to apply this method.

📌Steps

  • As we want to add 10 percent to the prices, we need to multiply them by 110% or 1.1.
  • So, enter either the following formulas in cell D9:
=$C$5

=$C$6

  • Then copy the formula down using the fill handle tool.

  • After that, select all the prices.
  • Next, press CTRL+C or right-click to copy.
  • Then, select cell D9.
  • After that, press CTRL+ALT+V for Paste Special. You can also find it by right-clicking.
  • Next, mark Multiply and then hit OK.

Paste Special Dialog Box

  • Finally, you will see the prices changed as follows.

Add 10 Percent to a Number using PasteSpecial

Read More: Percentage Formula in Excel (6 Examples)


Things to Remember

  • Some formulas contain absolute references. Make sure to enter the formulas correctly.
  • You must follow the steps correctly as numbered while using the Paste Special.

Conclusion

Now you know 2 quick and easy ways to add 10 percent to a number. Please use the comment section below for further suggestions or queries. You may visit our Exceldemy blog to learn more about excel and improve your performance.


Related Articles

Md. Shamim Reza
Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo