Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing txt csv files into Excel greater than 65k lines | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
Bold Grid Lines | Excel Discussion (Misc queries) |