I already tried that.

VBA doesn't accept { } character, so I can not write this formula!

But thanks for the help!

"Gary''s Student" wrote:

Follow:

http://spreadsheetpage.com/index.php...line_formulas/

Consider using VBA to place the formulas in worksheet cells or use
EVALUATE() to evaluate then directly.
--
Gary''s Student - gsnu200825


"Lucile" wrote:

Hello,
I need to do a polynomial regression, 5th order.
I think I am using the right formula: application.linest(x,y^{1,2,3,4,5})
My problem is that {} is not accepted! Invalid character.
I am using excel 2000.

What can I do to fix this problem?
Thanks