Intersection of two lines

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Intersection of two lines 5
Intersection of two curves 7
Intersection of two curves 4
intersection of two lines defined by points 7
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Intersection of two lines 2
How do i locate the point of intersection of two lines graphs 3
Blank Lines Question 2

Top