how can I solve two equation with excel?

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

Guest

how can I solve two equation with excel?
example:
x+y=1
4x-2y=5
x=?
y=?
 
One way is to select 2 vertical cells, and Array Enter:

=MMULT(MINVERSE({1,1;4,-2}),{1;5})

or as ranges:
=MMULT(MINVERSE(A1:B2),C1:C2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

solving of linear equation 5
Excel What does E represent in Microsoft Excel?? 1
Please solve this algebra equation? 1
Solving two equations with known exponent 5
Equation Selector 7
copy trendline equation to cells for use in other calculations 1
Can Excel describe a function in two variables: y = f(x,z) 3
Trendline equation and data do not match up 3

Back
Top