MINVERSE in Excel

MINVERSE Function in Excel

MINVERSE in Excel stands for “Matrix Inverse”. This built-in excel function converts the given matrix to the inverse matrix with the same number of arrays.

Having talked about the “inverse matrix” one needs to understand what exactly the “inverse matrix” is all about.

Inverse Matrix: The reciprocal of a number is called the “inverse matrix”. For example, for number 5, we can write the reciprocal as

So, the inverse matrix can be written in the same logic by using this equation “A-1 and the above number can be written as 5-1 as well. When we multiply a number by its reciprocal we always get 1 as the result. For example, the number 5 is multiplied with its reciprocal 1/5 we get the result as 13

Inverse Matrix 1

Similarly, when we multiply a matrix by its inverse we get the identity matrix i.e. “I”. Below is the equation of the identity matrix.

A * A-1 = I

When we talk about the inverse matrix in excelInverse Matrix In ExcelAn inverse matrix is defined as the reciprocal of a square matrix that is a non-singular matrix. The inverse matrix in excel has an equal number of rows and columns to the original matrix.read more we need to look at the identity matrix as well. With identity matrix all the number of rows and columnsRows And ColumnsA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read more are in equal numbers, with diagonally we get 1 as the value and apart from diagonal everything else will equal to zero.

So, the identity matrix will always be in the form of “2 * 2, 3 * 3, 4 * 4” like this.

Once the matrix is inversed we can cross-check whether it is inverted or not by using MMULT function in excel and we will get an identity matrix and it looks like this.

Inverse Matrix 1-1

Ok, let’s try these things with excel now.

Minverse-in-Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: MINVERSE in Excel (wallstreetmojo.com)

Example to use MINVERSE Excel Function

You can download this MINVERSE in Excel Template here – MINVERSE in Excel Template

For example, take a look at the below 3 * 3 matrix.

inverse matrix in Excel - Example 2
  • We have matrix numbers from A2 to C4, to reverse this matrix create an identical table next to the above table but do not keep the same values and keep the field empty.
inverse matrix in Excel - Example 2-1
  • In the range E2 to G4 we are going to create an inverse of the matrix. Select the range of cells from E2 to G4.
Minverse in Excel - Example 2-2
  • Now in the selected range of cells open excel MINVERSE function.
Minverse in Excel - Example 2-3
  • The first argument of MINVERSE function is array i.e. this nothing but the range of matrix values that we are trying to inverse, so our 3 * 3 matrix values are in the range of A2 to C4.
Minverse in Excel - Example 2-4

Before we close the formula one thing we need to keep in mind is “MINVERSE” is an array so we need to close out the formula by using “CSE” keys.

Note: CSE stands for “Ctrl + Shift + Enter”. So all the array formulas are closed with these keys only.
  • So, close the formula by hitting ENTER key by holding the “Ctrl + Shift” key together.
Minverse in Excel - Example 2-5

As you can see above we have got an “inverse matrix” by using MINVERSE function. Since it is an array formula we can see curly brackets ({}) at the start and end of the array formula.

Now we can cross-check whether this matrix is inversed or not by using MMULT function. MMULT function stands for “Matrix Multiplication”.

  • Now select the range of cells to create another identity matrix, so select the 3 * 3 matrix area.
Minverse in Excel - Example 2-6
  • Now Open MMULT function for the selected range of cells.
Minverse in Excel - Example 2-7
  • For the array1 argument of MMULT function choose “Matrix 1” range from A2 to C4.
Example 2-8
  • For array2 argument of MMULT function choose the “Inverse Matrix” range of cells from E2 to G4.
Example 2-9
  • MMULT is also an array function, so close the formula by using “CSE” keys to convert to array function.
Example 2-10
  • This result has given us decimal results, so use the ROUND function inside the array function to get an accurate “identity matrix”.
Example 2-11

Now we have got an “identity matrix” where we have 1 as the diagonal value. Like this, we can use MINVERSE function to inverse the matrix and MMULT to check whether it is reversed or not.

Things to Remember

  • MINVERSE function can accept only one matrix at a time.
  • This is an array function in excel so use “CSE” keys to close the formula.
  • When the matrix is inverse we can find the identity matrix by using MMULT function where we need to multiply the original matrix with the inverse matrix.

This has been a guide to MINVERSE in Excel. Here we learn how to use the MINVERSE function to inverse the matrix and by using Round and MMULT formula to get the identity matrix along with example and downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>