Intercept of 2 lines

[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.

 

[gls858]

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

 

[Guest]

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.

 

[Bernie Deitrick]

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