all I get is the slope result as a single number.

HI. Sounds like you are entering your function into 1 cell.
Select a few cells (rows & columns) and then Array enter your equation.

You should see different information in each cell.
= = =
HTH
Dana DeLouis


al boccia wrote:
I have been struggling to get the LINEST function to work for me. I have
checked out the instructions for the function, and have followed them
carefully, but I can't get LINEST to return either the basic results (slope
and intercept) or the full array of output (with the STATS option set to TRUE
(or 1). I am entering the formula as an array formala, as instructed. No
matter what I do, all I get is the slope result as a single number.

Any suggestions would be greatly appreciated.

Al Boccia