vikgarden

Posts: n/a

calculate monthly average percentage of change

Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
Percentage of increase is (10%, 36%, 33%)
Average monthly increase is 26%

How do I get excel to calculate the above?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate total interest earned on a loan and monthly payment	Matt Stanley	Excel Worksheet Functions	4	May 4th 23 03:42 AM
How do I create a formula to calculate the average percentage rat	LD	Excel Worksheet Functions	5	January 13th 05 06:17 PM
Calculate change over time	Gwen	Excel Worksheet Functions	0	January 1st 05 05:52 PM
calculate average hours and minutes	llstephens	Excel Worksheet Functions	4	November 30th 04 03:47 PM
calculate average hours worked	llstephens	Excel Worksheet Functions	1	November 24th 04 02:37 PM

All times are GMT +1. The time now is 03:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us