View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Doublee Doublee is offline
external usenet poster
 
Posts: 3
Default Trend Line constants as Excel Cell Values

If you are trying to solve for x knowing all the other terms, rearange the
equation:
x^2+Bx/A +C-Y =0 to ax^2+bx+c=0
Then use the solution for the roots:
(-b+-sqrt(b^2-4ac))/2a

"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