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.
- Change the format of the cell where you’re doing your calculation to percentage
- 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.