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