Math and Trignometric - MINVERSE Function

Description

The MINVERSE function returns the inverse matrix for the matrix stored in an array.

Syntax

MINVERSE (array)

Arguments

Notes

• Array can be given as a cell range, such as A1:C3 or as an array constant, such as {1,2,3;4,5,6;7,8,9} or as a name for either of these.

• Inverse matrices, like determinants, are generally used for solving systems of mathematical equations involving several variables. The product of a matrix and its inverse is the identity matrix. i.e. the square array in which the diagonal values equal 1, and all other values equal 0.

• If an inverse exists, the original matrix is known as invertible. Otherwise, the original matrix is described as singular.

• If a matrix is not invertible, MINVERSE returns the #NUM! Error value. The matrix is singular and the determinant is 0.

• Formulas that return arrays must be entered as array formulas.

• MINVERSE is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the cancellation is not complete.

• If any cells in Array are empty or contain text, MINVERSE returns the #VALUE! error value.

• If array does not have an equal number of rows and columns, MINVERSE returns the #VALUE! error value.

• If you select additional cells that are not part of the resulting matrix, MINVERSE returns the #N/A error value in these cells.

• If you do not highlight the full range of cells for the resulting matrix, Excel will just show the part of the result that fits into the highlighted range. There will be no error message to let you know that your highlighted range is not big enough.

• If you do not enter the formula as an array formula, the cell in which you enter the formula will just show you the first entry of the resulting matrix and there will be no error message.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example