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