copy trendline logarithmic constants to a cell

"Cheetha" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to copy trendline logarithmic constants to a cell for
> further
> calculations.

Can't you use the LOGEST() function?
--
David Biddulph

David -

Excel's logarithmic trendline fits y = c*LN(x) + b.

Excel's exponential trendline fits y = c*EXP(b*x).

Excel's LOGEST function fits y = b*m^x. The b value corresponds to c in the
trendline exponential function, and the m corresponds to EXP(b).

So, LOGEST is a worksheet equivalent to exponential trendline, not to
logarithmic trendline.

- Mike
www.mikemiddleton.com

"David Biddulph" <[email protected]> wrote in message
news:[email protected]...
> "Cheetha" <[email protected]> wrote in message
> news:[email protected]...
>> Is it possible to copy trendline logarithmic constants to a cell for
>> further
>> calculations.
>
> Can't you use the LOGEST() function?
> --
> David Biddulph