Aug 20, 2007 #1 marvic Marine/Ocean Joined Aug 20, 2007 Messages 1 Location AU 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 Joined Sep 6, 2005 Messages 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 Joined Oct 31, 2003 Messages 533 Location US 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 Joined Feb 4, 2004 Messages 1,543 Location US 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 Joined Oct 31, 2003 Messages 533 Location US 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 Joined Jun 3, 2002 Messages 44,899 Location US 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 Joined Feb 4, 2004 Messages 1,543 Location US 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 Joined Jun 3, 2002 Messages 44,899 Location US One and the same in Excel 5.0 and up TTFN FAQ731-376 Upvote 0 Downvote
Aug 24, 2007 #9 cr1973 Civil/Environmental Joined Jul 30, 2003 Messages 100 Location US Don't forget the old fashioned way - scale it off Upvote 0 Downvote
Aug 27, 2007 #10 M MintJulep Mechanical Joined Jun 12, 2003 Messages 10,250 Location JP 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.