View Single Post
  #4   Report Post  
MrShorty
 
Posts: n/a
Default Intersection point in graphs


In many cases, it is difficult or impossible to find an algebraic
solution like I suggested above. Back to the general case:

Set spreadsheet up so you have a cell calculating f(x)-g(x) at some x
that is reasonable. Then you can use Goal Seek or Solver (Goal Seek is
easier to use, but Solver is more robust) to numerically find the value
of x that yields f(x)-g(x)=0. There are hazards associated with such a
numerical solution (may converge to the wrong solution or may not
converge at all), but this approach is general enough to work in many
cases.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=480125