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
--------------------------------------------------------------------------------------------------------------
✅All our announcements are available here t.me/howtechtv
✅ Commercial questions [email protected]
✅ Instagram instagram.com/howtechprojects
✅ Twitter twitter.com/howtechprojects