Thanks again Jerry. That linked post gets me half way, I see one of the
coefficients in each case but the intercept is eluding me. I'll play around a
bit.
Interesting that the trendline numbers differ after about 10 decimal places...

"Jerry W. Lewis" wrote:

The archives of these newsgroups are generally a good place to start

http://groups.google.com/group/micro...687207210e1cde

Jerry

Incoherent wrote:

I am able to generate polynomial coefficients that match using LINEST but I
wonder if anyone knows how to get the coefficients and exponents for the
other type of trendlines.

Thanks