What is MINVERSE Function in Excel?
The MINVERSE function is one of the math functions of Excel.
It Returns the inverse matrix for the matrix stored in an array.
We can find this function in Math & trig category of insert function Tab.
How to use MINVERSE function in excel
- Click on an empty cell (like F5 ).
2. Click on fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select math and trig category.
5. Select MINVERSE function.
6. Then select ok.
7. In the function arguments Tab you will see MINVERSE function.
8. Array is a numeric array with an equal number of rows and columns, either a cell range or an array constant.
9. You will see results in the formula result section.
Examples of MINVERSE function in Excel
Example 1:
How to use MINVERSE function in excel
You can see examples of MINVERSE function below:
minverse(A2,B3) ----->>>>answer is {1,0;0,1}
minverse(A6,B7) ----->>>>answer is {-0.3,0.6;0.6,-0.3}
Example 2:
How to find the inverse of a matrix in Excel?
In the following examples, as you can see in the photo, the inverse of a matrix can be identified by the MINVERSE function.
minverse(A2,B3) ----->>>>answer is {0,0.5;0.5,0}
minverse(A6,B7) ----->>>>answer is {0.2,0;0,0.2}
What is the purpose of MINVERSE function?
It Returns the inverse matrix for the matrix stored in an array.
What is the Return value of MINVERSE function?
It returns a matrix.
How many arguments does MINVERSE function have?
This function has just 1 Argument.
The argument of MINVERSE function is matrix.
Array is a numeric array with an equal number of rows and columns, either a cell range or an array constant.
The argument of MINVERSE function is required and not optional.
MINVERSE(matrix) = matrix
Which version of excel supports MINVERSE function?
This function is available for all excel versions (2003-2019)
Errors in MINVERSE function
ERROR CASE:
1.Empty cells in the source array.
2. Row and column are not equal in the source array.
3. If the determinant of the matrix is zero, then it will not have an inverse; the matrix is then said to be singular. Only non-singular matrices have inverses.
minverse(A2,B3) ----->>>>answer is #VALUE!
minverse(A6,A7) ----->>>>answer is #VALUE!
minverse(A10,B11) ----->>>>answer is #NUM!