Excel 2010: Matrix Inverse Function (MINVERSE)

Previously we have covered how to evaluate the determinant of matrix. Now we will be focusing on how to find out inverse of the matrix which mainly requires multiplication of determinant with matrix ad-joint. The old-school method for evaluating inverse is very tedious but with Excel MINVERSE function, we can evaluate it instantly. We just need to write or specify data range values in matrix as argument of the function.

Launch Excel 2010 spreadsheet containing data in matrices. For instance, we have included spreadsheet containing fields; Matrix and Inverse.

table matrix

As you have noticed that there are three 2×2 matrices and one 3×3 matrix, we will be finding out inverse of the matrices through Excel inherent function rather than applying old-school method for evaluating matrix inverse which is;

Inverse (A)= |A| Matrix (Adj [A])

You must have been familiar with the evaluation process, it becomes so complex and tedious to manage. But we will be using MINVERSE function which will yield inverse of matrix instantly.

The basic syntax of the function is;

=MINVERSE(array)

Where array could be the data range or values entered in the form of array. We will be writing formula in the first matrix in Inverse column.

=MINVERSE(A2:B3)


Where A2:B3 is the range of matrix data in Matrix field. Select the first matrix in Inverse field i.e E2:F3. and write a formula as mentioned above.

formula

Now press Ctrl+Shift+Enter on keyboard to let Excel know that we are dealing with array. It will enclosed formula in parenthesis { =MINVERSE(A2:B3) }, as shown in the screenshot below.

array martix

Apply the formula by copying it and pasting it in other cells after selecting cells contain in other matrix.

For 3×3 matrix we will again write down the formula, select the cells contain in matrix and formula will go like this;

{ =MINVERSE(A14:C16) }

It yields the result of matrix inverse in selected cells, as shown in the screenshot below.

minver

You can also check out previously reviewed Matrix operation Function Evaluating Matrix Determinant (MDETERM) and other functions; DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.

Advertisement
  • Me

    How to do this with matrices of complex numbers?

  • Rodrigo Perin

    OK explanation until this point:
    “Apply the formula by copying it and pasting it in other cells after selecting cells contain in other matrix.”

    That part is not clear or doesn’t work.

    • http://www.facebook.com/andres.znidar Andres Znidar

      Before typing the formula, you should select all the cells of the new inverted matrix.
      And I agree it’s not clear.

  • Khalid Al-Ali

    Thank you

  • blackbeered

    I see four 2×2 matrices.