Using the Excel MINVERSE Function
SummaryThe 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.
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 NotesMINVERSE 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).