Power trendline

[kenppy]

I have a short two column result which I have charted and applied a power trendline to.
The result y=cx^b appears on the chart but how do I extract the constants b & c for use downstream?

thanks

[MrShorty]

I prefer to use LINEST().

1st -- linearize the equation: ln(y)=ln(c)+b*ln(x).
2nd -- setup a table with the new variables
3rd -- Use LINEST to get b and ln(c)

[kenppy]

thanks,

i used this one in the end

c = EXP(INTERCEPT(LN(yrange),LN(xrange)))
b = SLOPE(LN(yrange),LN(xrange))

from an earlier post in this forum
(btw, might be me but the search features are hit'n'miss)