MINVERSE

The MINVERSE function returns the inverse matrix of a matrix.

MINVERSE(matrix)

matrix: A numeric array with an equal number of rows and columns.

Notes

  • MINVERSE will return an error if the number of rows is not equivalent to the number of columns.

Examples

Given the following matrix:

A

B

1

1

2

2

3

4

=MINVERSE(A1:B2) returns the matrix below:

A

B

1

-2

1

2

1.5

-0.5

Calculated as

4/(1*4-2*3)

2/(2*3-1*4)

3/(2*3-1*4)

1/(1*4-2*3)

See alsoMDETERMMUNITMMULT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.