MINVERSE Function in Excel

In this post, you will learn about a Matrix function – MINVERSE function in Excel, how to use it in your excel spreadsheets.

MINVERSE Function in Excel

The function returns the inverse matrix of the given array.

Note:

  1. Array – An arrangement of objects in rows and columns.
  2. Matrix – An array of many numbers.

Syntax

=MINVERSE(array)

The syntax has a single argument

  • array – This holds the data of the square matrix.

How to use MINVERSE Function in Excel?

How to use MINVERSE Function in Excel?
  • The function returns the inverse matrix of the given array.
  • It is important to note that the array has to be a square matrix, or else the syntax returns #VALUE!.
  • Note: A square matrix is a combination of equal numbers of columns and rows.

Start with a Square Matrix in the Excel sheet.

How to use MINVERSE Function in Excel?
  • Highlight the new cells in a similar structure as the matrix and enter the syntax.
  • Highlight the matrix to include it in the syntax.
How to use MINVERSE Function in Excel?

To display the answer press Ctrl + Shift +Enter, this will display the answer in a complete matrix form. Or else only one value of the matrix will be displayed.

MINVERSE Function in Excel

Additional Points:

  • The function accepts negative numbers and decimal numbers.
  • When non – numeric values and alphabets are used the syntax returns the #VALUE!.
  • Empty cells in the source array will cause the function to return #VALUE!.
  • The MINVERSE Function with Ctrl + Shift +Enter step, is called a multi – cell array formula.