View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

This is so-called scientific notation; 3E+06 would be written by hand as 3 x
10 (power of 6). Of course this is 3,000,000 or 3 million

In A1:A10 enter 1,2,3...10
In B1 enter =533371*Ln(A1)-3E+06
Copy B1 down to B10

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Phil Hageman" wrote in message
...
I have a logarithmic trendline with the equation Y = 533371Ln(x) - 3E+06
associated with a line series. I want to create another series using this
equation (substituting 1, 2, 3, etc. for x) but don't know what "3E+06"
means, or how to set the equation up as a formula. Can someone explain
the
equation and show me how to set up my formula series?

Thanks,
Phil