Note: If you need to find the percentage of a total or find the percentage of change between two numbers, you can learn more in the article Calculate percentages.
Increasing a number by a percentage is a common task in Excel. Whether you’re calculating price increases, raises, interest rates, or any other growth metric, being able to increase a number by a percentage quickly and easily is an important Excel skill.
In this stepbystep guide, I’ll show you two simple methods to increase a number by a percentage in Excel using basic formulas. We’ll cover how to:
 Increase a number by a percentage using the PRODUCT and SUM formulas
 Increase a number by a percentage using only the PRODUCT formula
 Format the results as currency or with a percentage symbol
These methods work for any percentage increase or decrease I’ll use simple examples with sample numbers so you can clearly see how the formulas work
Overview of Increasing a Number by a Percentage
Increasing a number by a percentage involves multiplying the original number by 1 plus the percentage
For example, to increase 113 by 25%, you would calculate:
113 * (1 + 25%)
Which is:
113 * (1 + 0.25) = 113 * 1.25 = 141.25
So 113 increased by 25% is 141.25.
The key is understanding that to increase a number by 25%, you take the original number and multiply it by 1.25 (which is 1 + 0.25, or 125%).
This same concept applies to any percentage increase or decrease. The formula is:
Original Number * (1 + Percentage in Decimal Form)
Below I’ll show you how to calculate this in Excel using simple formulas.
Method 1: Increase a Number by a Percentage Using SUM and PRODUCT
The first method to increase a number by a percentage uses both the SUM and PRODUCT functions.
Here are the steps:

Enter the original number in any cell (A1 in this example).

In another cell (B1), enter the percentage increase or decrease as a decimal. For a 25% increase enter 0.25. For a 10% decrease enter 0.1.

In another cell (C1), enter the formula =SUM(1,B1). This adds 1 plus the percentage.

Finally, in another cell (D1), use the PRODUCT formula to multiply the original number by the sum calculated above: =PRODUCT(A1,C1)
This multiplies the original number by 1 plus the percentage to increase or decrease it.
For example:
A1: 113B1: 0.25 C1: =SUM(1,B1) = 1.25D1: =PRODUCT(A1,C1) = 141.25
So for an original number of 113 and a 25% increase, the final result is 141.25.
This method works for both percentage increases and decreases. Just change the percentage in step 2 to a negative number for a decrease.
The benefit of this method is it breaks the calculation down into small steps that are easy to understand. The downside is it uses two formulas instead of just one.
Next, I’ll show you an even easier method.
Method 2: Increase a Number by a Percentage Using Only PRODUCT
An even simpler way to increase a number by a percentage in Excel is to use only the PRODUCT formula.
Here are the steps:

Enter the original number in any cell (A2 in this example).

In another cell (B2), enter the percentage increase or decrease as a decimal. For a 25% increase enter 0.25.

In another cell (C2), use this PRODUCT formula: =PRODUCT(A2,1+B2)
That’s it! The formula multiplies the original number by 1 plus the percentage to increase or decrease it.
For example:
A2: 113B2: 0.25C2: =PRODUCT(A2,1+B2) = 141.25
This method combines steps 3 and 4 from the previous example into a single formula.
Formatting the Results as Currency or Percentage
Once you have the calculated results, you can format them as currency or percentages for better readability:

To format as currency, select the cells with the results, click the Home tab, then click the Currency Number Format button. This displays the results with a currency symbol and two decimal places.

To format as a percentage, select the cells with the results, click the Home tab, then click the Percent Style button. This displays the results followed by a percentage symbol.
So for the above examples, you could format cell D1 or C2 as currency to display $141.25 or format it as a percentage to display 141.25%.
Increasing a Number by a Percentage In Practice
Now let’s look at a few examples of how to use these methods in practice.
Example 1: Calculating Price Increase
Say your product costs $100 normally. You want to calculate the new price after increasing it by 10%.
Using Method 1:
A3: 100B3: 0.10 C3: =SUM(1,B3) = 1.10D3: =PRODUCT(A3,C3) = 110
So a 10% price increase on a $100 product is $110.
Using Method 2:
A4: 100B4: 0.10C4: =PRODUCT(A4,1+B4) = 110
Example 2: Calculating Interest Earned
If you have $5,000 invested earning 4% annual interest, how much interest will you earn in a year?
Using Method 1:
A5: 5000B5: 0.04C5: =SUM(1,B5) = 1.04D5: =PRODUCT(A5,C5) = 5,200
So at a 4% interest rate, you will earn $200 interest on a $5,000 investment.
Using Method 2:
A6: 5000 B6: 0.04C6: =PRODUCT(A6,1+B6) = 5,200
Example 3: Calculating a Decrease
Your salary is currently $60,000. Due to company cutbacks, it will be decreased by 6%. What is your new decreased salary?
Using Method 1:
A7: 60000B7: 0.06C7: =SUM(1,B7) = 0.94D7: =PRODUCT(A7,C7) = 56,400
So a 6% decrease on a $60,000 salary is $56,400.
Using Method 2:
A8: 60000B8: 0.06 C8: =PRODUCT(A8,1+B8) = 56,400
Recap and Additional Tips
To quickly recap how to increase a number by a percentage in Excel:
 Use the formula: Original Number * (1 + Percentage)
 Enter the percentage as a decimal, like 0.25 for 25%
 Use the SUM and PRODUCT formulas together or just the PRODUCT formula
 Format as currency or percent for better readability
Here are some additional tips:
 To decrease a number, enter the percentage as a negative decimal like 0.10 for a 10% decrease
 You can use a cell reference for the percentage like B1 instead of entering the decimal directly
 This works for any percentage increase or decrease, not just the examples shown
 Experiment with your own numbers to get comfortable with the formulas
Increasing numbers by percentages is a critical Excel skill used across many applications like finance, accounting, and sales. Master these simple techniques using SUM, PRODUCT, and formatting to increase your spreadsheet productivity.
Change an amount by a percentage
Lets say you need to decrease—or want to increase—your weekly food expenditures by 25%. To calculate the amount, use a formula to subtract or add a percentage.
In this example, we set column B to contain the amount currently spent, and column C is the percentage by which to reduce that amount. Heres is a formula you could enter in cell D2 to accomplish this:
=B2*(1C2)
In this formula, 1 is equivalent to 100%. The values inside the parentheses calculate first, so ther value of C2 is subtracted from 1, to give us 75%. The result is multiplied by B2 to get a result of 56.25 for Week 1.
To copy the formula in cell D2 down the column, doubleclick the small square green box in the lowerright corner of cell D2. You get the results in all of the other cells without retyping or copyingandpasting the formula.
To increase the amount by 25%, simply replace the + sign in the formula in cell D2 sign to a minus (–):
=B2*(1+C2)
Then doubleclick the filldown handle again.
Multiply an entire column of numbers by a percentage
Consider an example table like the one in the figure, in which weve got a few numbers to multiply by 15 percent. Even if the column has 100 or 1,000 cells of data, Excel can still handle it in a few steps.
Here’s how to do it:
 Enter the numbers you want to multiply by 15% into a column.
 In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing CtrlC.
 Select the range of cells A1:A5 (by dragging down the column).
 Rightclick over the cell selection, and then click Paste Special (do not click the arrow next to Paste Special).
 Click Values > Multiply, then click OK. The result is that all the numbers are multiplied by 15%.
Tip: You can also multiply the column to subtract a percentage. To subtract 15%, add a negative sign in front of the percentage, and subtract the percentage from 1, using the formula =1n%, in which n is the percentage. To subtract 15%, use =115% as the formula.
How to add 10 percent in excel//increase 10 percent in excel//Excel tutorial// learn It 9M
How do you calculate a percentage increase in Excel?
In your second cell, place the percentage value you are using to increase your number. Using the previous example, place 10% in cell B2. This is the second value to use in the formula when calculating the percentage increase value. 3. Enter the percentage increase formula
How do you increase a number by a percentage?
To increase a number by a specified percentage, simply multiply that number by 1 plus the percentage increase. For example, to increase a product’s price by 15% (which was $250), use this formula: =$250* (1+15%) =$250* (115%) =$287.5 After calculation, the new price is $287.50. We can generalize the formula to calculate the percentage increase as:
How to calculate percentage increase in Excel & Google Sheets?
This tutorial will demonstrate how to calculate the percentage increase (or increase a number by a percentage) in Excel & Google Sheets. To increase a number by a specified percentage, simply multiply that number by 1 plus the percentage increase. For example, to increase a product’s price by 15% (which was $250), use this formula: =$250* (1+15%)
How do you calculate a percentage in Excel?
After filling in both your number and percentage values, multiply the number by one plus the percentage increase with the formula “=A2*(1+B2).” To do this, enter the formula in the cell next to your percentage cell and press the “Enter” key to compute it. For the example, this would be =100*(1+10%), which equals an adjusted price of $110.