Hi there ,
How can I get the exact intersection point between two curves .
Hi there ,
How can I get the exact intersection point between two curves .
Excel doesn't have a built in all purpose utility or function for finding the intersection point, but there are multiple strategies/algorithms that one can program into Excel. Choosing an algorithm/strategy is mostly about knowing what kind of problem you have.
If your curves are defined by two straight line functions, you can use strategies like this: https://www.excel-easy.com/examples/...equations.html
If your curves are defined by non-linear functions or you don't like the previous strategy, then you can use Excel's Solver utility to find the intersection point. You will need to play around with the functions to come up with an objective function (maybe f1-f2 will work), then call Solver and tell it to find the max min or value (if you use f1-f2, then you will find when the objective is 0) of the objective function subject to any constraints needed to control the algorithm. https://www.mrexcel.com/excel-tips/i...ion-to-solver/
If your curves are defined by tabulated values, then you will need to decide if you want to use an interpolation algorithm or a regression algorithm. Then implement your chosen algorithm, then use either of the strategies above to find the intersection point.
That should give a quick overview of the problem. If you need further help, provide some details of your specific problem, and we should be able to help with more detailed solutions.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks