Excel MINVERSE Function

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

  1. Click on an empty cell (like F5 ).
empty cell in excel

2. Click on fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select math and trig category.

5. Select MINVERSE function.

6. Then select ok.

excel MINVERSE function

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.

How to use MINVERSE function in excel

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!

    MINVERSE related functions :

    Leave a Reply

    Your email address will not be published. Required fields are marked *