Thanks a lot for your help.. I guess I haven't been drinking enough coffee
today ;)

"Tushar Mehta" schreef:

I'm surprised you figured out the first two and then got stumped by the
last two.

y=a*ln(x)+b is of the same form as y=a*z+b!

So, a=Slope(y,ln(x)), and b=intercept(y,ln(x))

The other equation, y=a*exp(b*x), can be rewritten as
ln(y)=ln(a) + ln(exp(b*x)) or
ln(y)=ln(a) + b*x

So, a=exp(intercept(ln(y),x)) and b=slope(ln(y),x)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions