I can't get the forecast formula to work?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows XP Closing stock Forecast formula 0
Forecasting with formulas HELP 1
Excel Forecasting Dates Out to the Day 3
SORT data containing formula 5
how to get totals? 1
If...rows and columns 3
simple countif formula 2
Next highest Value 1

Back
Top