Adding a certain percentage of a number to its previous value is quite a common feature in everyday life. By finding a certain percentage of a value we can use it in various ways. In the economy or in an office environment it may be a salary increment. It can be a particular growth rate of a population of a country in a certain year. It can be a selling price of a product at a certain profit margin. You may want to learn how to add 10 percent to a number in Excel. The possibilities are endless. Here 5 quick and user-friendly methods to add 10 Percent to a number in Excel are described step by step in Excel.
📁 Download Excel File
Download the Excel file from here
Learn to Add 10 Percent to a Number with These 5 Methods
In this article, we are going to learn five easy and efficient methods to determine how to add 10 Percent to a number from a particular value. Here a salary sheet of the employers of a company is provided. Let’s assume they are going to get a 10 percent raise in the next month. So we are going to determine what their increased salary would be by using Excel. Here, I am going to show you some easy methods to add 10 percent to a number in Excel.
1. Multiplying with Fixed Cell Reference
Here we will use the absolute cell reference to determine the 10% increased salary for a list of employees of a certain company. A step-by-step description is given below.
⬇️⬇️ STEPS ⬇️⬇️
- Here at first, we lock the cell value of C5 using F4. After locking the cell value we add 1 to it and then multiply it with cell value C8.
- After the first step, we get the value of cell D8. But it is only a single-cell value.
- So to find the total value from the data set we need to copy this value to the other cells as well. For this purpose, we need to use the Fill Handle icon.
- We drag the cell function to the other cells by using it. By doing this we are basically copying the formula to other cells as well.
- After using the Fill Handle option the function implies the total range of the cell.
- So we will be able to see the calculated value for the total data set of our data table.
- Here the final snapshot is given to provide a better understanding.
Read More: 3 Quick Ways to Add 20 Percent to a Price in Excel
2. Using Percentage Data Type
Here we are going to see the step-by-step breakdown of determining the employee salary for the same data set. But we are going to use the Percentage data type instead.
⬇️⬇️ STEPS ⬇️⬇️
- We can also take advantage of the percentage data type to add 10% to a number as well.
- In the first step, we make a simple function at cell E6 by multiplying the cell value of C6 and D6.
- But here in D6, we used the percentage data type for the increment column set.
- In our second step, we again use the Fill Handle We drag the value of E6 all the way to the E10.
- Thus we copy the formula to all our data sets in column E.
- In our final step, we can see that the formula is working and we are able to get our result for our data set.
- But in this case, we used different data types to solve our requirements.
Read More: 3 Ways to Add Percentage to Price in Excel with Formula
3. Calculating Increment Then Adding with Old Salary
Here we are going to see how to get the increment first and then use that incremented value to determine the updated salary for the same data set of employees.
⬇️⬇️ STEPS ⬇️⬇️
- In this method, we have to create an extra column for determining the increment for determining increased employee salary.
- Then in cell E6, we use a simple formula by multiplying the cell values C6 and D6 to determine the salary increment at first.
- In the second step, we use another simple formula in cell F6 by summing the cell value of C6 and E6 to get the updated salary for the employee.
- In this step, we again use the Fill Handle option to copy the formula from E6 to E10. By doing this our cell E gets updated.
- In our final step, we again use the Fill Handle option in column F and get a new salary for the data set in column F.
Read More: Calculate Percentage in Excel Using Absolute Cell Reference
4. Multiplying with Decimal Equivalent
Here we are going to use another different data type which is Fraction. The breakdown steps are as follows:
⬇️⬇️ STEPS ⬇️⬇️
- In this method, we use fraction data type to get our updated salary.
- In the first step, we use a formula in cell E6 by simply multiplying the cell value of C6 and D6.
- In the second step, we use the Fill Handle option to drag our formula from cell E6 all the way to cell E10.
- Thus we copy the formula to all the cells in column E.
- In the final step, we can see our result for the data set. All the value from column E gets updated.
5. Using Paste Special Feature
Here we are going to show the use of a special tool called Paste Special. We can determine the salary of the employee instantly by using this efficient and useful tool. The steps are given below.
⬇️⬇️ STEPS ⬇️⬇️
- Our last method to demonstrate how to add 10 percent to a number in Excel is by using the Paste Special feature.
- In the first step, we have to copy our present salary to column D first. Now we will use a copy-paste special tool to update this column.
- In this step at first, we copy the cell value of C5.
- Then we select the data range from C8:C12 and give a right click.
- Then we will select the Paste Special option from there. As a result, a dialogue box will appear.
- We have to select the operation Multiply from the dialogue box. Then click OK.
- Thus we will see the new salary in column D.
How To Add 5 / 20 / 25 / 50 or Any Percent to a Price in Excel
Here we are going to learn in a simple way how to add any particular number to a price using an Excel formula. The step-by-step procedure is given below:
⬇️⬇️ STEPS ⬇️⬇️
- In the first step, we get the cell value of D8 by simply adding the cell value of B8 and C8.
- Then we use the Fill Handle option to drag down the formula all the way to D12 from D8.
- Thus we can copy the formula to the whole range.
- In the final step, we get the value of the price increasing by 20 for all the data sets.
- You can also Add Numbers to Existing Cell Values in Excel in a similar way.
- You can also use any other kind of number to get your desired result too.
How to Reduce a Number by a Percentage in Excel
Here we are going to see how we can reduce a number by a percentage in Excel. We are showing a data set containing the discount percentage to demonstrate the procedure.
⬇️⬇️ STEPS ⬇️⬇️
- In the first step, we get the sell value of D8 by multiplying the cells C8 and B8 from the existing B8.
- In the next step, we use the Fill Handle option. It helps to drag down the formula from D8 to D12.
- Thus we can copy the formula for the whole data set.
- In the final step, we can see the discount price of the other products too.
- Thus we can determine the discount price for a product after the discount.
📄 Important Notes
🖊️ The important thing to remember in our methods is that we should select the data type carefully. A mix of different types of the data type may cause errors.
🖊️ While using fixed cell reference we have to make sure that we have locked that cell properly. Otherwise, we will not get the desired result.
📝 Takeaways From This Article
📌 We can use different data types to add a certain percentage to a number in Excel.
📌 We can use Paste Special tool instead of Fill Handle to do an operation between two different columns.
Conclusion
In order to add 10 percent to a number in Excel we have seen 5 different methods. You can use either a different data type, fixed cell reference, or Paste Special tool for this purpose. Readers can comment in the comment section for any query. The author will try to answer them. You can follow ExcelDen for more Excel related solutions.
Related Articles
- 3 Easy Ways to Calculate Accuracy Percentage in Excel
- 4 Simple Ways to Calculate Forecast Accuracy Percentage in Excel
- Calculate Percentage in Excel Based on Conditional Formatting
- 4 Easy Ways to Calculate Percentage in Excel Based on Cell Color
- 6 Ways to Forecast Growth Rate in Excel