I have three lines defined by a simple data set. What I would like to do is calculate the point of intersection btwn lines 1&2 and lines 2&3. I've tried the intersectcomplex function but didn't get the right results. I've attached an example of the type of data I'm working with.
Thanks in advance.
because this function calculaltes the intersection with the y-axis.
It makes a 2e order function first and than uses:
y=ax+b
a=(y1-y2)/(x1-x2) and b=y1-ax1 or b=y2-ax2
This way you can find x where y = 0 (zero) and that is x=-b/a.
This does not help you, but is for information.
Are your function logaritmic (exponential)? as you give only two points and use exponential axis!
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
See attached.
Last edited by shg; 11-13-2009 at 01:56 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks