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:

=MINVERSE(B2:C3)

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.