Skip to content

Calculating percentage change in Excel

If you do a lot of work in Excel, odds are you’ve needed to calculate a percentage change. Luckily, Excel does this for you quite readily if you simply apply a basic formula of (New Value - Old Value)/Old Value. There is, however, a pitfall that you’ll not get the values you expect if the cell where you’re entering the value is not set to percentage formatting. Hence, here’s a step to step way to make the calculation:

For the sake of this example, the new value is found in cell F35, and the new value is found in cell B35.

  1. Change the format of the cell where you’re doing your calculation to percentage
  2. Enter the formula =(F35-B35)/B35

That should see you sorted.

By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.