Excel: Minverse Function

In Excel, the Minverse function returns the inverse matrix for a given matrix.

The syntax for the Minverse function is:

Minverse( array )

array is an array of numbers. The array must have the same number of rows as the number of columns.

Note:

If any of the cells in the array contain empty or non-numeric values, the Minverse function will return the #VALUE! error.

If the array does not contain the same number of rows as the number of columns, the Minverse function will return the #VALUE! error.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Minverse(A1:B2) would return 5.966850829

=Minverse(A1:C3) would return #VALUE!

=Minverse({1,2;3,4}) would return -2

=Minverse({1,2,1;3,4,2;1,1,2}) would return -2