Decimals in equation from trendline

[PoloRB]

Does anyone know how to see more decimals in the equation derived from the trandline of thechart?
For instance, I have an exponential chart with the following equation:
y = 87.26e-0.00x

i want to be able to see at least 4 decimals in order to know the real value of the constant (or multiplier) of x.

I know it could be done with Excel 3 but I am working with Excel 7 and I can not find the way.

thanks in advance

[shg]

Welcome to the forum.

To see the m and b for the exponential y = exp(b)*exp(m*x), select a two-cell wide range (e.g., A1:B1), paste this in the formula bar,

=LINEST(LN(y), x)

... and confirm with Ctrl+Shift+Enter rather than just Enter.

Then m is in A1 and and b is in B1.

[PoloRB]

Welcome to the forum.

To see the m and b for the exponential y = exp(b)*exp(m*x), select a two-cell wide range (e.g., A1:B1), paste this in the formula bar,

=LINEST(LN(y), x)

... and confirm with Ctrl+Shift+Enter rather than just Enter.

Then m is in A1 and and b is in B1.

Thanks for your reply; unfortunatelly it did not work.
I am attaching a file where you can see what i am talking about.

[shg]

Change X and Y in the formula to references to your data ...