Logarithmic Trendline Equation

[Phil Hageman]

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

 

[Bernard Liengme]

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

 

[Phil Hageman]

Thanks Bernard, appreciate the help. Phl

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