Microsoft® Excel® 2010 Formulas & Functions Inside Out

MINVERSE()

Syntax. MINVERSE(array)

Definition. This function returns the inverse of an array.

Argument

• array (required) A numeric array with an equal number of rows and columns

Background. Inverse arrays are generally used for solving equations involving several variables. For an array to be inverted, it has to be a square array. The array cannot be a singular array—that is, an array whose determinant ≠ 0 (see the description of the MDETERM() function earlier in this chapter).

The inverse of an array is indicated by –1 (array A becomes A–1). The equation Ax=b becomes x=A–1b.

The inverse can be calculated by using the following methods:

• Gaussian elimination method The Gaussian elimination method is often used to manually calculate inverses. A detailed ...