I have these two formulas:
x+y=10
x-y=-1
I have to graph these two get the point where they intersect (x,y) as the answer. Can anyone help me.
Thanks
I have these two formulas:
x+y=10
x-y=-1
I have to graph these two get the point where they intersect (x,y) as the answer. Can anyone help me.
Thanks
That's an algebra problem, not an Excel problem.
Add the two formulas to eliminate y, solve for x, and plug that value into either formula to get y.
Entia non sunt multiplicanda sine necessitate
In that case, can you use solver for this equation?
I'm sure Solver could be used for solving systems of linear equations, but there are much better algebraic techniques (that can be programmed into Excel). I would suggest a quick review of your secondary math about solving systems of equations. I find these to be decent tutorials: https://www.purplemath.com/modules/systlin1.htm
Originally Posted by shg
...I have to graph these...
solve each eqn for y
in Excel, enter a range of values for some -x to +x
in col's B and C enter the formulas corresponding to the y solutions above with the X cells as y values
Last edited by protonLeah; 11-18-2018 at 04:08 PM.
Ben Van Johnson
As the OP asked for a solver solution:
solv_graph.jpg
And as the values for X and Y are set by the constraint there is no need to set the objective.
solv_graph_sol.jpg
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks