learn excel - Percentage growth formula
Resolved · Low Priority · Version Standard
Caroline has attended:
Excel Intermediate course
Percentage growth formula
Do you know what formula you type to work out the percentage growth of a series of numbers over a time period? i.e. how much each consecutive figure has increased/decreased by?
For upcoming training course dates see: Pricing & availability
RE: percentage growth formula
Thanks for your question.
The formula will involve a subtraction and a division. For example, if:
then the formula is =(Feb value - Jan value)/Feb value
You will need to format the cell containing the formula to display as a percentage as well.