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