[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

MINVERSE({3,6,1;1,1,0;3,10,2}) results in 2
MINVERSE({3,6;1,1}) results in -0.333333333


end example]