In Excel, we often came across a situation where we have to add a percentage to a number.

This is often the case when we want to increase or decrease a value by a certain percentage value.

For example, let’s say we want to increase the price of all the products in a store by 10%. This could be done by adding 10 percent to the price of all the products.

In this tutorial, I will show you various methods and some** quick tips to add a percentage to a number in Excel**.

## Method 1: Add Percentage to Number Using Percentage Formula

We can add a percentage to a number using the percentage formula.

For demonstration purposes, I have a data set where I have product names in column A and their sales in column B.

Now what I want is to increase the price of all the products by 10%. For that, I am going to use the below formula that will add 10 percent to the price of all the products.

Price + (Price * 10 /100)

For the first product (Jeans) the formula is described below

B2 + (B2 * 10 / 100)

Now drag the formula in the entire column to add 10 percent to the price of all the products.

To copy the formula, click and drag the Fill Handle (plus icon) that appears when moving the cursor to the bottom-right of the selected cell.

This will increase the price of all the products by 10% as shown in the below screenshot.

Similarly, you can also subtract the percentage from a number with little modification in the above formula as below.

Price - (Price * 10 /100)

Note that the result of the formula is dynamic, which means that in case you change the price of any cell in column B, the value in Column C will automatically update

Also read: Convert Number to Percentage in Excel

## Method 2: Add Percentage Using the Decimal Equivalent of Percentage

In this section, we will see how we can add a percentage to a number using the decimal equivalent of a percentage.

For demonstration purposes, I have a data set where I have product names in column A and their sales and column B.

Now we will use the decimal equivalent of percentage. Instead of using 10% in the formula, we can use its decimal equivalent which is 1.1. The formula would become

Price * 1.1

For the first product (Jeans) the formula is described below

B2 * 1.1

Now write the formula in Excel as shown below

Copy the formula in the entire column to add 10 percent to the price of all the products.

To copy the formula, click and drag the Fill Handle (plus icon) that appears when moving the cursor to the bottom-right of the selected cell.

This will increase the price of all the products by 10% as shown in the screenshot

If you want to add any other percentage then change the decimal equivalent of that percentage.

For instance, let’s say you want to increase the price of the product by 30% then use the formula

=Price * 1.3

Similarly, you can also decrease the price of a product as well. Let’s say you want to provide a 30% discount on all the products the formula would be

=Price * 0.7

## Method 3: Add Percentage By Multiplying the Number with Percentage Value

In this section, we will see how we can add the percentage to a number by multiplying the number by a percentage.

For demonstration purposes, I have a data set where I have product names in column A and their sales in column B.

Let’s say we want to increase the price of all the products by 10 percent.

You can do so by multiplying the price of the product by 110% (100% as the full original price plus 10% as the desired increase).

=Price * 110%

For the first product (Jeans) the formula is described below

=B2 * 110%

Now write the formula in Excel as shown below

Copy the formula in the entire column to add 10 percent to the price of all the products.

To copy the formula, click and drag the Fill Handle (plus icon) that appears when moving the cursor to the bottom-right of the selected cell.

This will increase the price of all the products by 10% as shown in the screenshot

Similarly, you can decrease the price of all the products by 10 percent.

You can do so by multiplying the price of the product by 90% (100% as the full original price minus 10% as the desired decrease)

## Method 4: Add Percentage to Number Using Paste Special

In this section, I will show you how you can use Paste Special to add a percentage to a number.

Here, I am going to use a sample data set where I have product names in column A and their sales in column B.

- Enter the value of the percentage in any cell as shown below. In this case, I have entered 110% in the cell (where 100% is the original price value and 10% for the price increase that we need to calculate)

- Select and copy the price of all the products by pressing CTRL + C from the keyboard

- Paste the values in the Price (10% increase) column by pressing CTRL + V from the keyboard

- Now copy the Increase By value by pressing CTRL + C from the keyboard

- Now select the range for which you want to increase the price by adding a percentage

- Right-click on the selection and choose the option Paste Special

- This will open a dialog box. Choose the Values and Multiply options as highlighted in the below screenshot

- Click ok

This will increase the price of all the products by 10% as shown below.

Note that the result in cells in column C is static. This means that in case you change the Price values in Column B, the values in Column C wouldn’t update and you will have to redo the above steps again

In this tutorial, I showed you various methods of adding percentages to a number where I add 10 percent to the existing price of products using different approaches.

Similarly, I also showed you how you can also subtract the percentage from a number.

**Other Excel articles you may also like:**

Steve,

I’m a retired Fleet Manager, and am having a problem with a simple formula. I have a column with formula calculated percentages which is working fine, and the cells are formatted to percentage, which display fine. My problem is that I have a fixed dollar amount in a cell that I’m trying to add to the next column, but can’t figure out what the correct formula is. I can do it on paper using a calculator, but just can’t figure out what I’m doing wrong with the formula in excel.

Example: using calculator $7847.64 + 23.62% = $9701.25

Base Allowance $7847.64 which is in Z11

Retirement Year CPI = 709.156 which is in N13

Current Year CPI = 876.664 which is in N21

876.664 – 709.156 = 167.508 / 709.156 = .23620 or 23.62%

Excel N21 N13 W21 N13 X21

fixed fixed =SUM(N21-N13) =SUM(W21/N13)

The problem is the last Z21 where I’m adding Z11 to X21 to get $9701.25 I would think it would be =SUM(Z11+X21) but it just gives me

$7847.88 I know it’s got to be just something simple I’m doing wrong.

Thanks for your assistance.