| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate projected figure
Mark Stephenson Wrote: Hi, I need to calculate a projected figure, based on previous months... i.e; JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 123 345 677 899 1002 1400 ??? ??? ??? ??? ??? ??? The number is cumulative from month to month.... I have previously used the average of the difference between the months, but this is not that great to use... Are there any functions in excel that can do this for me? Many thanks, Mark. Hi Mark You might find the attached useful, look in the Worksheet Functions sheet +-------------------------------------------------------------------+ |Filename: Forecast etc.zip | |Download: http://www.excelforum.com/attachment.php?postid=4096 | +-------------------------------------------------------------------+ -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=490696 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate 20% of a total figure | Excel Worksheet Functions | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| Splitting a Target Figure | Excel Worksheet Functions | |||
| Can someone help with a formula to calculate dates? | Excel Discussion (Misc queries) | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
Threaded Mode
