Hey Jason.

Here's what I did... see if it works for you.

Insert a row somewhere near your quarter headings (I did above my version of
your data). Then instead of using the year and Q#, just input 1 above
FY07Q1, 2 above FY07Q2, etc. These will represent your known X values.

In the cell under FY08Q3 use the formula wizard to select forecast. In the
X value, place a 3 (since you are trying to find a forecasted value for
FY08Q3.) For the known y's, select your current data points (2.76, 2.40,
2.07 etc). And for the known x's you'll need to select the numbers in the
new row you added. Once you hit OK you'll have a value for FY08Q3. You'll
need to repeat the process in FY08Q4, changing the X from 3 to 4 and then
selecting your data all over again.

Hope this helps.
--
Just a fellow Excel user here to help when I can.....


"Jason Hall" wrote:

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