Intercept of 2 lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
flaterp said:
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.
Click to expand...
Home work?

hint: try subtracting or adding the same value from both sides
of the equation.
gls858
 
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.
 
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
 
Back
Top