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.
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.