How to Add a Percentage to a Number in Excel?

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. 

Dataset with price

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)
Formula to Add a Percentage to a Number in Excel

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.

Apply formula to entire column

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 would automatically update

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.   

Dataset with price

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

Formula to Add a Percentage to a Number in Excel

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

Copy formula to the entire column

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.   

Dataset with price

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

Formula to Add a Percentage to a Number in Excel

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

Apply formula to entire column

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.   

Dataset with price
  1. 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)
Enter the expected percentage value in a cell
  1. Select and copy the price of all the products by pressing CTRL + C from the keyboard
Copy the price data
  1. Paste the values in the Price (10% increase) column by pressing CTRL + V from the keyboard
Paste it into adjacent column
  1. Now copy the Increase By value by pressing CTRL + C from the keyboard
Copy the cell that has the increase by value
  1. Now select the range for which you want to increase the price by adding a percentage
Select the cells where you want to add the percentages
  1. Right-click on the selection and choose the option Paste Special
Click on Paste Special
  1. This will open a dialog box. Choose the Values and Multiply options as highlighted in the below screenshot
Select Values and then Multply
  1. Click ok
Click Ok

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

Price increased by 10%

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: