Calculating Change %

By saying change %tage – we essentially mean that the percentage of increase or decrease of a number from its original value to a new value.

To calculate the increase percentage: First: get the difference (increase) between the two numbers you are comparing. Then: divide the increase by the original number and multiply the answer by 100.

If your answer is a negative number, then this is a percentage decrease.

Calculating Change % in MS Excel

Let’s understand how to calculate this in MS Excel.

Suppose we have a number ‘X’ which has changed to a new value called ‘Y’, then the change % would be calculated as under:


Equation Example 1


  1. Hi Sir, this is really a very helpful and easy formula to calculate change%. Thanks, pls keep sharing such useful calculation tricky formulas. Thanks!!


Please enter your comment!
Please enter your name here

Captcha verification failed!
CAPTCHA user score failed. Please contact us!

Recommended Reads

Latest Articles