# 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. ## 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. 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. 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)` Formula 4:

• You can also multiply the prices by the decimal equivalent of the percentage. This will give the same result too. • 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. ### 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. • Finally, you will see the prices changed as follows. 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.

## Related Articles 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 Advanced Excel Exercises with Solutions PDF  