Hi Ken,

Supposing your x-range is in A2:A10, and y-range in B2:B10,

select a 3-column x 1-row area and enter the following formula and confirm
with CTRL-SHIFT-ENTER.

=LINEST(B2:B10,A2:A10^{0,1,2},0,)

Regards,
B. R. Ramachandran

"Ken" wrote:

I want to put the constants of a 2 degree polynomial trend line into Excel
Cells. Are there formula's to do this? Equation is Y = Ax(2) + Bx + C. I want
the value of A,B and C in seperate cells. Can anyone suggest how this can be
done? Thanks
--
Ken