Intersection of two lines

C

cpp492

Does anyone know how to find the intersection point of two lines in excel?
I've already plotted by data (2 lines) and they intersect. I've added linear trend lines and have the equations shown but was wondering if there was a worksheet function that at least gave the intersection point, on either axis.
thanxs.
 
J

Jerry W. Lewis

If your two lines are
y = a1 + b1*x
y = a2 + b2*x
Then solving
a1 + b1*x = a2 + b2*x
for the x value at intersection is basic high school algebra. Then plug
that x value into either equation to get y.

Jerry
 
Top