Tangent to a curve

[Nick]

Hi,

Hope someone can help...I'm looking for a way to find a
tangent to a curve using excel. Is there a way to find the
closest point between two ranges using functions?

Thanks for any help,

Nick

 

[Jerry W. Lewis]

Do you know the equation of the curve (in which case why not
differentiate it?) or do you just have selected values?

Not sure what you mean by "the closest point between two ranges"

Jerry

 

[Nick]

Hi Alan,

I've got formula for the curved line. I plan to
differentiate after I get the correct x value.

Say the x axis is time. I need to know at what point in
time the slope of the straight line is the same as the
slope of the curve. From this I could get the intercept of
the straight line, which is really what I'm after!

I was hoping someone knew of a clever way to get "x", so I
could automate it.

Thanks,

Nick

-----Original Message-----