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: