MINVERSE
Syntax:
MINVERSE ( array )
Description: Computes the inverse of the square matrix of numbers designated by array. The inverse matrix is calculated with an accuracy of at least 15 digits, which can lead to a small numeric error when the cancellation is not complete.
Arguments:
Name |
Type |
Description |
---|---|---|
array |
array, reference |
Designate a square matrix of numbers. |
Return Type and Value: number – The inverse of the square matrix designated by array.
However, if
Any cells in array are empty or contain text, the return value is unspecified.
The matrix designated by array is not square,
#VALUE!
is returned.The matrix cannot be inverted, the return value is unspecified.
example: