Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelMINVERSE Function in Excel

# 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?

• 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.

• Highlight the new cells in a similar structure as the matrix and enter the syntax.
• Highlight the matrix to include it in the syntax.

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.

• 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.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021