I can't get the forecast formula to work?
 

If i enter each number it works, but i want to set up the formula and do it
over a lot of cells. I'm using numbers that were taken in a different sheet.

ex. =forecast(2005,{1,2,3},{9,8,7}) this would work just fine

but

when i do this
=forecast(b1,{b2,b3,b4},{b5,b6,b7}) it doesn't work, actually it won't even
let me us the "{"

Hi. This array formula gives the same answer:
=FORECAST(B1,B2:B4,B5:B7) (Ctrl+Shift+Enter)

HTH
--
Dana DeLouis
Win XP & Office 2003


"Andy G" <Andy wrote in message
...
If i enter each number it works, but i want to set up the formula and do
it
over a lot of cells. I'm using numbers that were taken in a different
sheet.

ex. =forecast(2005,{1,2,3},{9,8,7}) this would work just fine

but

when i do this
=forecast(b1,{b2,b3,b4},{b5,b6,b7}) it doesn't work, actually it won't
even
let me us the "{"