How to Calculate a Percentage Increase in Excel

In this video, we’ll be showing you how to calculate a percentage increase in Excel.

Percentage increase shows how much the previous value increased or decreased relative to itself. If you start with 100 and add another 100 to make 200 then you have increased the original value by 100%. Percentage increase is handy because it shows growth or decline in a very tangible way. We’ll now create a percentage increase formula in Excel.

1. Select the cell that you want the percentage increase formula in.
2. In this example we are going to subtract the previous month from the current month and then divide that by the previous month and that will give us the percentage increase between months.
3. The formula is: =(D7-C7)/C7.
4. You will probably get a decimal number so go under the Home tab at the top and click the Percent Style button under the Number Category.
5. You can then hover the cursor on the bottom right of the cell with the formula until the cursor changes then click and drag it down the column. Notice that percent decreases are negative.

Now you can calculate percent increases! Remember that the previous number is always subtracted from the current number and then that difference is divided by the previous number.

❓💬 What other formulas or percentage calculations do you want to learn? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------

[marcellafredericks]

I have never been able to learn excel from a video. THANK YOU! It worked and I am so happy because you made this easy to understand and it was short!

[misterwill]

Excellent explanation! Short and to the point!

[jbubala]

Thank you! This is so much easier than trying to use conditional formatting or new rules

[omarreza]

Huge help this video is 2 years old but is still super helpful👍

[shardglobalsales]

Thank you :-) I'm useless at maths but getting better with your simple help, appreciate you :-)

[jerrybauer]

I have to say the same thing- you saved me! Thanks

[karthij]

I'm also saying that,
'Thank you man. You saved me.'

[arisu]

my formula was like yours, but it turned to $0. Then I added the percent style, it converted to 2%.

[lemonsarejuicy]

I've done for Formula but I want to put the boxes empty so anyone can use it with their own data, but on the percentage increase cell its says #DIV/0! does anyone know how to fix this?

[arisu]

it didn't work on my excel sheet. I wonder why?

[cyrenesing]

Your explanation versus what you did are not the same, FYI 😊