Find intersection between to lines

%3CLINGO-SUB%20id%3D%22lingo-sub-2756635%22%20slang%3D%22en-US%22%3EFind%20intersection%20between%20to%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2756635%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20find%20the%20point%20of%20intersection%20between%20to%20lines%20in%20excel.%20The%20blue%20dots%20are%20from%20column%20D%20and%20E%20and%20the%20orange%20is%20from%20column%20F%20and%20G.%20i%20have%20a%20lot%20of%20data%20and%20saw%20another%20way%20on%20the%20community%20on%20how%20to%20do%20it%20but%20i%20cant%20figure%20it%20out%20in%20my%20excel%20sheet.%20I%20am%20using%20excel%20on%20mac.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohanSund563_0-1631805224238.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310806i7E7FFF2033EB6F1D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JohanSund563_0-1631805224238.png%22%20alt%3D%22JohanSund563_0-1631805224238.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2756635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2757785%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20intersection%20between%20to%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757785%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20read%20the%20image.%26nbsp%3B%20It%20is%20too%20small%3B%20and%20it%20becomes%20blurry%20when%20I%20zoom.%26nbsp%3B%20It%20is%20always%20better%20to%20attach%20an%20actual%20Excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20ask%20about%20the%20intersection%20of%20two%20%22lines%22.%26nbsp%3B%20Usually%2C%20the%20word%20%22line%22%20means%20a%20%3CEM%3E%3CU%3Estraight%3C%2FU%3E%3C%2FEM%3E%20line.%26nbsp%3B%20But%20to%20my%20tired%20eyes%2C%20the%20blue%20%3CU%3E%3CEM%3Ecurve%3C%2FEM%3E%3C%2FU%3E%20does%20not%20appear%20to%20be%20straight.%26nbsp%3B%20Am%20I%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20yes%2C%20would%20a%20linear%20approximation%20(trendline)%20of%20the%20blue%20curve%20be%20sufficient%20for%20your%20purposes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20mathematical%20formulas%20for%20the%20two%20(straight)%20lines%20are%20y1%20%3D%20a1*x%20%2B%20b1%20(orange)%20and%20y2%20%3D%20a2*x%20%2B%20b2%20(blue)%2C%20where%20a1%2C%20a2%2C%20b1%20and%20b2%20are%20constants%20and%20y1%20and%20y2%20are%20names%20(like%20%22x%22)%2C%20not%20cell%20references%2C%20they%20intersect%20at%2C%20then%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ex%20%3D%20(b2%20-%20b1)%20%2F%20(a1%20-%20a2)%3C%2FP%3E%3CP%3Ey%20%3D%20a1*x%20%2B%20b1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20cannot%20translate%20the%20mathematics%20into%20Excel%20formulas%20for%20your%20worksheet%2C%20then%20again%2C%20it%20would%20behoove%20you%20to%20attach%20the%20Excel%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey! 

I would like to find the point of intersection between to lines in excel. The blue dots are from column D and E and the orange is from column F and G. i have a lot of data and saw another way on the community on how to do it but i cant figure it out in my excel sheet. I am using excel on mac. 

JohanSund563_0-1631805224238.png

 

1 Reply

I cannot read the image.  It is too small; and it becomes blurry when I zoom.  It is always better to attach an actual Excel file.

 

You ask about the intersection of two "lines".  Usually, the word "line" means a straight line.  But to my tired eyes, the blue curve does not appear to be straight.  Am I right?

 

If yes, would a linear approximation (trendline) of the blue curve be sufficient for your purposes?

 

If the mathematical formulas for the two (straight) lines are y1 = a1*x + b1 (orange) and y2 = a2*x + b2 (blue), where a1, a2, b1 and b2 are constants and y1 and y2 are names (like "x"), not cell references, they intersect at:

 

x = (b2 - b1) / (a1 - a2)

y = a1*x + b1

 

If you cannot translate the mathematics into Excel formulas for your worksheet, then again, it would behoove you to attach the Excel file.