Exceljet

Quick, clean, and to the point

Excel MINVERSE Function

Excel MINVERSE function
Summary 

The Excel MINVERSE function returns the inverse matrix of a given array. The input array must contain numbers only and be a square matrix, with equal rows and columns. The result is an inverse matrix with the same dimensions as the array provided.

Purpose 
Get inverse matrix of array
Return value 
Inverse matrix as array with same dimensions
Syntax 
=MINVERSE (array)
Arguments 
  • array - A square array of numbers only.
Usage notes 

The MINVERSE function returns the inverse matrix of a given array. The product of a matrix and its inverse is the identity matrix. An n × n square matrix with ones on the main diagonal and zeros in every other position. 

In order for MINVERSE to calculate an inverse matrix, the input array must contain numbers only and be a square matrix, with equal rows and columns. When an inverse exists, MINVERSE returns an inverse matrix with the same dimensions as the array provided.

In the example shown, the formula entered across the range M7:O9 is:

{=MINVERSE(I7:K9)}

To display the resulting array directly in a worksheet, MINVERSE must be entered as a multi-cell array formula with control + shift + enter.

Notes

  1. The input array must be a square matrix with an equal number of rows and columns
  2. The array argument can be provided as a range or array constant like {4,3;3,2}
  3. Empty cells in the source array will cause MINVERSE to return the #VALUE! error
  4. MINVERSE returns the #VALUE! error value if array does not have an equal number of rows and columns.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.