View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default Useing a Logrithmic y=intercept in a cell

The coefficient values are rounded by default. You can format the
trenline coefficients to display full precision (scientific notation
with 14 decimal places), or you can calculate then directly in Excel

http://groups.google.com/group/micro...d0f2172c25a661

Jerry

swissforestry wrote:

Of course within minutes of postingt this i figure it out.

y = 16.899Ln(x) - 11.928


translates to this:

=(16.899)*LN(B5)-11.928