LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Forecast Formula help

Ok, I have read and reread the forecast function and I still have questions....

Scenario:
I need to forecast a dollar value for the 2 quarters based on the last 6
quarters dollar value.

Example:
FY07Q1 FY07Q2 FY07Q3 FY07Q4 FY08Q1 FY08Q2 FY08Q3 FY08Q4
$2.76 $2.40 $2.07 $2.36 $2.00 $2.17

Issue:
Can't figure out how to set the forumla up to forecast FY08Q3 and FY08Q4


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Need help with formula to forecast revenue dj479794 Excel Discussion (Misc queries) 2 November 30th 07 09:35 PM
Formula-Compound Sales Forecast GatorGirl Excel Discussion (Misc queries) 4 March 6th 07 05:04 PM
forecast formula question Dan_Green Excel Worksheet Functions 2 August 4th 05 09:07 AM
I can't get the forecast formula to work? Andy G Excel Worksheet Functions 1 June 17th 05 01:03 AM
Forecast Formula Sandra Cummins Excel Discussion (Misc queries) 2 March 7th 05 12:41 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"