Math/Excel – How to Calculate Percentage Change
I am working on graphs and I need to find the percentage of increase from one figure to another. How do I do that? For instance staff hours for 2006 were 28011 and for 2007 were 31230. How do I find the percentage of increase?
Percentage change is calculated this way:
The sign indicates whether it is a decrease or increase. For your example,
- Since this is a positive figure, it is an 11.5% increase.
Hope this helps!