In the below example, we have list of products with their actual values and their related budget values.
Your job is to calculate the percentage change.
We will let “A” represent Actual and “B” represent Budget. Our formula will be Actual minus Budget divided by Budget.
Another way to write this is Actual divided by Budget minus Budget divided by Budget.
Which turns into Actual divided by Budget minus 1.
In our sample file, we will select cell D5 and enter the following formula:
Fill the formula down the remainder of the table and apply a percent style to the results.