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.
Writings worth keeping