MINVERSE (inverse matrix)

<< Click to Display Table of Contents >>

MINVERSE (inverse matrix)

Syntax:

MINVERSE(Array)

Description:

Returns the inverse of a square matrix.

The inverse A-1 of a matrix A is the matrix that A has to be multiplied by to receive the identity matrix 1.

Array is a cell range or array containing the matrix to be evaluated. It must contain numeric values only. Its number of rows has to equal its number of columns.

Annotation:

Matrices whose determinant is zero (singular matrices) cannot be inverted. In this case, the 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