Explanation
Note: you must format the result using Percentage number format to display the final result as 7%
Related formulas
Calculate percent variance
Get original number from percent change
Percent sold
Get percent change
To calculate the percentage change between two values in Excel, you can use a formula that divides the difference between two values by the "old" value. In the example shown, E6 contains this formula: =(D6-C6)/C6 When formatted as a percentage with zero decimal places, the result is 7%.
