Aug 20, 2007 #1 marvic Marine/Ocean Aug 20, 2007 1 Can anyone let me know as to whether I can get the intersection point of two ploted lines in excel
Aug 21, 2007 #2 40818 Aerospace Sep 6, 2005 459 I dont know if there is an inbuilt function, but i have managed to do so previously by using IF statements and adding extra data in the spreadsheets. Upvote 0 Downvote
I dont know if there is an inbuilt function, but i have managed to do so previously by using IF statements and adding extra data in the spreadsheets.
Aug 21, 2007 2 #3 Clyde38 Electrical Oct 31, 2003 533 This may be a little more than what you want, but it may help..... http://www.andypope.info/charts/intersection.htm Upvote 0 Downvote
This may be a little more than what you want, but it may help..... http://www.andypope.info/charts/intersection.htm
Aug 22, 2007 #4 bacon4life Electrical Feb 4, 2004 1,533 That looks slick, but how does it work? Typing the same formula in a new spreadsheet gives a #NAME error? Upvote 0 Downvote
That looks slick, but how does it work? Typing the same formula in a new spreadsheet gives a #NAME error?
Aug 22, 2007 #5 Clyde38 Electrical Oct 31, 2003 533 Download the file and open in EXCEL. Alt F11 and read, it's is fairly well documented. Upvote 0 Downvote
Aug 22, 2007 #6 IRstuff Aerospace Jun 3, 2002 44,774 The reason you need to download the file is that the function is a custom function, otherwise, it would simply be a usage tip. TTFN FAQ731-376 Upvote 0 Downvote
The reason you need to download the file is that the function is a custom function, otherwise, it would simply be a usage tip. TTFN FAQ731-376
Aug 22, 2007 #7 bacon4life Electrical Feb 4, 2004 1,533 Ah! I was pressing ALT+F8 to edit/view the macro and it would only show my personal macros. Still not quite sure the difference between a visual basic script and a macro. Upvote 0 Downvote
Ah! I was pressing ALT+F8 to edit/view the macro and it would only show my personal macros. Still not quite sure the difference between a visual basic script and a macro.
Aug 22, 2007 #8 IRstuff Aerospace Jun 3, 2002 44,774 One and the same in Excel 5.0 and up TTFN FAQ731-376 Upvote 0 Downvote
Aug 24, 2007 #9 cr1973 Civil/Environmental Jul 30, 2003 100 Don't forget the old fashioned way - scale it off Upvote 0 Downvote
Aug 27, 2007 #10 M MintJulep Mechanical Jun 12, 2003 10,135 If your data is truly linear you could get the slope and y-intercept for both lines using the LINEST() function and use Goal Seek or Solver. Upvote 0 Downvote
If your data is truly linear you could get the slope and y-intercept for both lines using the LINEST() function and use Goal Seek or Solver.
