CODEWITHSUNDEEP
exceltrendline
haver24
haver24

Reputation: 251

getting coefficients of logarithmic trendline, EXCEL

I was wondering, whether it's possible to get coefficients of logarithmic trendline from an excel chart ? I know you can display them, but I'd like to have them in two different cells. Thanks in advance for help !

best regards, Bartek

Upvotes: 2

Views: 7154

Answers (1)

lori_m
lori_m

Reputation: 5567

First result for Google search "logarithmic trendline formula excel" works for me:

http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/

Note that you can right-click the trendline equation and choose Format Trendline Label... with Scientific Format and 14 decimal places to see full precision.

Upvotes: 1

Related Questions