array results not returned

J

JRM-drof

When using the LINEST formula in the array mode, I do not get the regression
statistics as promised by the formula when Stats is set to TRUE. I'm using
the example given in The Excel 2003 Article ID 829249.
 
B

Bernie Deitrick

JRM,

Are you using Ctrl-Shift-Enter instead of just Enter, and have your selecta a 6 column by 5 row area
prior to entering the formula?

HTH,
Bernie
MS Excel MVP
 
J

JRM-drof

Bernie,
Thanks for the suggestion. It was the correct thing to do. Previously I'd
only used one cell expecting that Excel would populate the appropriate number
of cells with the answer.

If the Microsoft people are monitoring this, perhaps they could update the
formula or include this tidbit in the help file for this function.

Thanks again. I'm no longer frustrated by this function.
 

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

Top