Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Percent Increase
Say I have the data listed below:
January - 250 February -275 March - 350 April - 400 May - 500 June - 650 July - 1000 August -1250 September -1600 October - 2000 November - 2600 December - 2750 Here is the formula I used: =(February/January)-1 Once all the months are done then average all the percents together to get a monthly percent increase average... I want to get monthly percent increase then get an average monthly percent increase of all months. Please advise the easiest way to do this and what the formula would be. Thanks, nolanstern |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CHART HELP Percent of Increase | Excel Discussion (Misc queries) | |||
Percent of increase each year | Charts and Charting in Excel | |||
Percent increase | Excel Discussion (Misc queries) | |||
Percent increase | Excel Worksheet Functions | |||
Percent Increase | Excel Discussion (Misc queries) |