Please help

How can I post this function into a cell:

y = 16.899Ln(x) - 11.928

This is the Y-intercept from a tredline. If you right click a line in a
scatter chart, you can click "show trendline". Under trend line, you can
ask it to display the formula. That is where I got this formulla. So, I
want to put this into a cell so I can "drag" it down to solve for X.

I.E. With a standard (non logrithmic) line my formula looks like this:

y = 0.4121x + 13.416, which I translate into the cell to this:

=0.4121*B5+13.416

From that I can drag it down to fill in the blanks.

Now, I cant do this with the logrithmic line, becuase I havent figured
out how to paste the function for "Ln"

Anyone know how?


--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719
View this thread: http://www.excelforum.com/showthread...hreadid=496445