An Excel logarithmic trendline attached to a data series has the following:

Equation Y=533371Ln(x)-3E+06.

R2 = 0.9533 (a good fit for the data)

Final value (where the trendline crosses the right-hand (secondary)

axis) =

~420,000 (the value Iâ€™m ultimately seeking)

I have created a new series with this equation to create the same curve with

the following:

Formula: =533371LN(1)-3000000

Final value produced with this formula: 195,673 (obviously not close

to the

Excel value ~420,000)

Changing the â€œ-3E+06â€? value to 2,600,000 produces 414,873 â€“ which very

closely approximates the value of the Excel trendline where it crosses the

right-hand axis.

Conclusion: Excel is rounding the 2,600,000 number up to 3 in the â€œ-3E+06â€?

factor of the equation.

Questions:

Is there a way to tell Excel not to round up to 3, but rather

use/display the exact number, something around 2,600,000, in place of

â€œ-3E+06â€??

Or, is there another way to find the exact â€œ-3E+06â€? number Excel uses

when it creates the equation?

## Bookmarks