# 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.*

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.

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.

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.

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.

#### Leave a comment

- Me
- Rodrigo Perin
- Andres Znidar

- Khalid Al-Ali
- blackbeered