Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 "{" |
#2
|
|||
|
|||
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 "{" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Formula doesnt work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions |