Calculate X using Excel : y = 6E+07ln(x) - 1E+09

Hi All,

I'm trying to get the specific data points from a trend-line. I have the formula: y = 6E+07ln(x)-1E+09

but i am having difficulty making an excel function that will calculate X for me.

Can anyone help???

please!!!

Thanks

y=6^7*ln(x)-1^9
ln(x)=(y-1^9)/(6^7)
x=e^((y-1^9)/(6^7))

Hi

or see attached.

Regards
Alan

Thanks guys!

Problem solved