View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Hall Jason Hall is offline
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