<< Click to Display Table of Contents >> MINVERSE (inverse matrix)

Syntax:

MINVERSE(Array)

Description:

This returns the inverse of a square matrix.

The inverse A-1 of matrix A is the matrix by which A must be multiplied to obtain the identity matrix 1.

Array is a cell range or array containing the matrix to be evaluated. It must contain numeric values only and be square, i.e., have the same number of rows and columns.

Additional info:

Matrices whose determinant is zero (singular matrices) cannot be inverted. In this case, the MINVERSE function returns a #NUM! error value.

Note:

Formulas using this function have to be entered as an array formula. For more information, see Working with arrays.

Example:

MINVERSE({9,8,8;2,4,6;1,2,1}) returns:

{0.2,-0.2,-0.4;-0.1,-0.025,0.95;0,0.25,-0.5}

See also:

Section Working with arrays, MDETERM, MMULT, MSOLVE, TRANSPOSE