Multiply the result by the percentage in its percentage form eg. So divide by the old value and make it a percentage. Divide 5000 by 100 to get y.
Percentage change 20 - 16 16 This gives the result 025 or 25.
Finally multiply that number by 100 to get the percent change. Now we will see how to solve these problems in an excel worksheet. If want to calculate percentage change in Excel this can be done using a simple Excel formula. Enter an old number in cell A1 and a new number in cell B1.