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.
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.
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 Calculate Percentage of a Number in Excel (5 Easy Ways)
Similar Readings
- How to Calculate Reverse Percentage in Excel (4 Easy Examples)
- How to Calculate Bacterial Growth Rate in Excel (2 Easy Ways)
- Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)
- Formula to Calculate Discount Percentage in Excel
- How to Calculate Variance Percentage in Excel (3 Easy Methods)
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.
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
- How to Calculate Percentage of Sales in Excel (5 Suitable Methods)
- Calculate Percentage Increase between 3 Numbers in Excel
- Calculate Year over Year Percentage Change in Excel (3 Easy Techniques)
- How to Calculate Grade Percentage in Excel (3 Easy Ways)
- How to calculate salary increase percentage in Excel [Free Template]
- Percentage Difference between Two Percentages Excel (2 Easy Ways)