## 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?

**MINVERSE**

It Returns the **inverse matrix for the matrix stored** in an array.

## What is the Return value of **MINVERSE** function?

**MINVERSE**

It returns a matrix.

## How many arguments does **MINVERSE** function have?

**MINVERSE**

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?

**MINVERSE**

This function is available for all excel **versions **(2003-2019)

## Errors in **MINVERSE** function

**MINVERSE**

**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!