Finding the X and Y intercept of two curved lines

**azorn92** · 07-01-2015, 10:38 AM

I would like to create a couple cells that spit out the intersection of two lines even if I change my input data. From what I have read it is fairly complicated. Thanks for the help!

**sweep** · 07-01-2015, 10:59 AM

Hi,

Please see the attached file..

**azorn92** · 07-01-2015, 12:08 PM

Thank you sweep, that's a cool spread sheet to find the intersection, is it applicable to large and multiple data sets?

**sweep** · 07-02-2015, 08:20 AM

Large shouldn't be a problem, but you'd have to modify it to accommodate multiple data sets.

Finding the X and Y intercept of two curved lines

LinkBack

Thread Tools

Rate This Thread

Display

Finding the X and Y intercept of two curved lines

Re: Finding the X and Y intercept of two curved lines

Re: Finding the X and Y intercept of two curved lines

Re: Finding the X and Y intercept of two curved lines

Thread Information

Users Browsing this Thread

Similar Threads

Plot with curved lines

Finding a Formula with a LINEST() Style-Function for a Curved Line

Unable to make lines on a graph move through an arc whilst maintaining y intercept

Finding X-axis Intercept

Intercept of 2 lines

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions