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.

Start with a Square Matrix in the Excel sheet.

• 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