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.

**Method**

### 1. Multiplying with Fixed Cell Reference

Here we will use the **a****bsolute 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**

**Method**

### 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**

**Method**

### 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**

**Method**

### 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.

**Method**

### 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
**P****aste Special**option from there. As a result, a dialogue box will appear. - We have to select the operation
**M****ultiply**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**