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

We often need to add a certain percentage to a number. This article shows 2 quick and easy methods for 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.

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

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 using 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 of 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.

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.

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!
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF