Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
flaterp
 
Posts: n/a
Default Intercept of 2 lines

Is there a solution to solving the intercept of two lines using the equation
of a line? For instance, Line 1 is y = 2x+3 and Line 2 is y = 3x -5. Set
them equal to each other and 2x+3 = 3x-5. How can I solve the last equation?
Thanks in advance.
  #2   Report Post  
gls858
 
Posts: n/a
Default

flaterp wrote:
Is there a solution to solving the intercept of two lines using the equation
of a line? For instance, Line 1 is y = 2x+3 and Line 2 is y = 3x -5. Set
them equal to each other and 2x+3 = 3x-5. How can I solve the last equation?
Thanks in advance.

Home work?

hint: try subtracting or adding the same value from both sides
of the equation.
gls858
  #3   Report Post  
flaterp
 
Posts: n/a
Default

Yes, I know this, but there are two problems: 1) The equations are more
complicated than the one I listed and 2) The list of data/equations is longer
than I would like to do this manually. Again, I ask how to do this in Excel,
not on paper.

"gls858" wrote:

Home work?

hint: try subtracting or adding the same value from both sides
of the equation.
gls858

  #4   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Use Solver, setting (Equation1)-(Equation2) = zero, and use the same cell
for your X values reference in your formula (and have Solver change that
cell).

HTH,
Bernie
MS Excel MVP


"flaterp" wrote in message
...
Yes, I know this, but there are two problems: 1) The equations are more
complicated than the one I listed and 2) The list of data/equations is

longer
than I would like to do this manually. Again, I ask how to do this in

Excel,
not on paper.

"gls858" wrote:

Home work?

hint: try subtracting or adding the same value from both sides
of the equation.
gls858



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing txt csv files into Excel greater than 65k lines strippier Excel Discussion (Misc queries) 1 April 20th 05 06:34 PM
How do I delete filtered lines in Excel 2000? Nicola H Excel Worksheet Functions 1 February 8th 05 03:47 PM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 10:43 PM
Bold Grid Lines Ctunes Excel Discussion (Misc queries) 1 December 8th 04 09:00 PM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"