array results not returned

[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.

[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


"JRM-drof" <JRM-drof@discussions.microsoft.com> wrote in message
news:68393FC6-DA52-4CDF-9836-11397B502DCA@microsoft.com...
> 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.

[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.

"Bernie Deitrick" wrote:

> 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
>
>
> "JRM-drof" <JRM-drof@discussions.microsoft.com> wrote in message
> news:68393FC6-DA52-4CDF-9836-11397B502DCA@microsoft.com...
> > 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.
>
>
>