## How to use the MINVERSE function

*Article updated on April 17, 2018*

The MINVERSE function calculates the inverse matrix for a given array.

This function is useful for solving equations with multiple variables.

Array formula in cell B5:C6:

The MINVERSE function must be entered as an array formula.

To enter an array formula, type the formula in a cell range then press and hold CTRL + SHIFT simultaneously, now press Enter once. Release all keys.

The formula bar now shows the formula with a beginning and ending curly bracket telling you that you entered the formula successfully. Don't enter the curly brackets yourself.

Cell range B8:C9 and B11:C12 shows how the MINVERSE function calculates the inverse matrix.

### Excel Function Syntax

MINVERSE(*array*)

### Arguments

array |
Required. An array containing numbers, the number of rows and columns must be the same. |

### Comments

The MINVERSE function returns #VALUE if:

- the argument contains text or blanks.
- the number of rows and columns don't match.

### Functions in 'Math and trigonometry'

The MINVERSE function function is one of many functions in the 'Math and trigonometry' category.