[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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:
MINVERSE({3,6,1;1,1,0;3,10,2}) results in 2
MINVERSE({3,6;1,1}) results in -0.333333333
end example]