MINVERSE and MMULT

Looking for an easy way to solve a system of equations? Calc can can do this for you.

Functions used:

MINVERSE(Array)
MMULT(Array,Array)

Let's look at each function individually:

MINVERSE(Array) - This function calculates the inverse of a square array. Square array means the array has the same number of rows as it does columns.

MMULT(Array,Array) = This function calculates the product of two arrays. The number of columns in the first array must be the same as the number of rows in the second array.

Take a look at the screen shots below. I have posted this file. It is called system of equations. You download by clicking on "Spreadsheet Function Files" under "Links" on the right hand side of the page.

This screen shot is for cells A13:C15



This screen shot is for cells B18:B20



And here is a screen shot of my results. The answers are in cells B18:B20