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 Im 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?