How do I locate a point of intersection between two lines on Excel?

I will assume you have two straight lines - if not please tell me what they

are.

Let the lines follow the two functions

y1=m1x1+b1 and y2=m2x2+b2

Let the point of intersection be Y and X

Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,

X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))

and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100

Select A1:B100 and Copy

Click chart; use Edit |Paste Special| specify New Series with X-value in

first cell

Click OK

Now the chart has the point of intersection as a marker.

best wishes

Good luck!