Re: How to use the LINEST function?

[Jean Bréfort <jean brefort normalesup org>]

Le vendredi 18 ao�06 �1:39 -0300, John Coppens a �it :
> Hi all... 
> 
> Please, a hand!
> 
> I've tried to use the LINEST function, and I can only get the M
> coefficient. THe docs say it is supposed to return two cols by one
> row, so I tried to select two adjecent cells, and call LINEST again.
> 
> I've tried to find manuals for other ss's, and tried it that way,
> no luck... only the first coefficient appears.
> 

The LINEST function returns an array. Use Ctrl+Shift+Enter as explained
in section 5.2.4.5 of the documentation
(http://www.gnome.org/projects/gnumeric/doc/sect-data-formulas.html).