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
|