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.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...