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.
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 Add 15 Percent to a Price in Excel
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.
Download Practice Workbook
You can download the practice workbook from the download button below.
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
- Excel Formula to Add Percentage Markup
- How to Do Sum of Percentages in Excel
- How to Add Percentage to Price with Excel Formula
- How to Add 20 Percent to a Price in Excel
- How to Subtract a Percentage in Excel
- How to Subtract a Percentage from a Price in Excel
- How to Subtract 10 Percent in Excel
- How to Use Excel Formula to Calculate Percentage of Grand Total
<< 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!