ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I do a system of equations? (https://www.excelbanter.com/excel-discussion-misc-queries/14409-how-can-i-do-system-equations.html)

jomamma

How can I do a system of equations?
 
Such as 2 equations and 2 unknowns.

Jason Morin

Here's one way. Assume your 2 equations a

2x + 2y = 8
x + 4y = 7

Place the coefficients of x in A1 and A2, coefficients of
y in B1 and B2, and the constants in C1 and C2. It should
look like this:

A B C
1 2 2 8
2 1 4 7

Select D1:D2, enter the formula below:

=MMULT(MINVERSE(A1:B2),C1:C2)

and press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
Such as 2 equations and 2 unknowns.
.



All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com