Explanation
Following order of operations, Excel first calculates the difference between the values (the actual change in sales) then divides that result by the original, or "old" value to get the decimal value -0.3435:
=(D6-C6)/C6
=(49500-75400)/75400
=-25900/75400
=0.0688
Note: you must format the result using Percentage number format to display the final result as 7%
Related formulas
Calculate percent variance
In this example, the goal is to calculate the variance between a Forecast (column C) and Actual (column D) as a percentage. For example, with a Forecast value of 100,000 and an Actual value of 112,000, we want to return a variance of 12%. The concept of variance requires a baseline value and a "new...
Get original number from percent change
In this example, the goal is to calculate the "original" number when the current value and percentage change are known. In other words, given that the current value is 1100 and the percentage change is known to be 10%, we want to return the starting value of 1000. The general formula for this...
Percent sold
In this example, the goal is to calculate the percentage sold for each item listed in the table, where original number (Total) is in column C and the Sold number is in column D. In other words, if we know we started with 144 apples, and sold 108 apples, we want to calculate that 75% of the apples...
