Value of LINEST

Hi All,
I got problem when using the LINEST function (linear regression). How do one add the value of the slope to a cell?

I use the code below but I get the #VALUE! message in the cell. The cell's format is General.

Please Login or Register  to view this content.

What is wrong here?

Cheers!

Ok I found the answer for a 2nd degree and I guess it will solve all my problems;

Please Login or Register  to view this content.

Please remember to use code tags when posting any code.

Here is the offical message with links on explanation.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You could also do,

Please Login or Register  to view this content.