MINVERSE

Using the Excel MINVERSE Function

Summary

The Excel MINVERSE function returns the inverse matrix of an array. The input matrix must be a square matrix, with equal number of rows and columns. The input matrix must also contain numbers only.

Syntax

=MINVERSE (array)

Syntax Breakdown

Array
Required. Numeric array with an equal number of rows and columns and containing only numbers. The array can be entered as a range, an array constant, or as a name for either a range or constant.


Usage Notes

MINVERSE returns the inverse matrix of an array. The identity matrix is the product of a matrix and its inverse. MINVERSE should be entered as a multi-cell array formula using Control + Shift + Enter to display the results in a worksheet.

If the array argument contains text or empty cells the function returns the #VALUE! error. The function also will return the #VALUE! error if the array doesn't have an equal number of rows and columns.

Some square matrices cannot be inverted. If this is the case, the function returns the #NUM! error. The determinant for a noninvertable matrix is 0 (zero).