98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel - Percentage growth formula
learn excel - Percentage growth formula
Resolved · Low Priority · Version Standard
Mon 19 Mar 2007, 09:22Delegate Caroline said...
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?
Mon 19 Mar 2007, 12:55Trainer Amanda said...
RE: percentage growth formula
Hi Caroline,
Thanks for your question.
The formula will involve a subtraction and a division. For example, if:
Month Value
Jan 12
Feb 6
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.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
