learn excel - Percentage growth formula

The UK's most regular instructor-led training courses.
Training information: learn excel · Excel courses london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Percentage growth formula

Caroline has attended:
Excel Intermediate course

by - delegate Caroline [2 posts] (2007 Mar 19 Mon, 09:22) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: percentage growth formula

by - trainer Amanda platinum contributer [947 posts] (2007 Mar 19 Mon, 12:55) Reply

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

· Take the Anxiety out of Domestic Finances with Microsoft Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Office and the Small Business: Part 1 Excel
· Crazy Things People Have Done With Excel

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips