<< 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