I found this when I was posed with simultaneous equations with 5 variables.
=mmult(minverse(a2:b5),e2:e5)
the above function should be used like this:
a2:b5 – This is the array where you arrange your variables (equations)
Then e2:e5 are the constants
Now select 5 cells in a column, and type the formula given above, replacing the array and constants respect to what you have entered in your sheet. Press CTRL+ENTER (not just enter), and the values of the five variables will be populated in the 5 cells.
0 comments: on "Calculate Simultaneous Equations in Excel without Solver"
Post a Comment