Navigation:  Formula Reference > Spreadsheet Formula Functions >

MINVERSE

Previous pageReturn to chapter overviewNext page

 

This function returns the inverse matrix for the matrix stored in an array.

Syntax

MINVERSE(array)

Arguments

The array is a numeric array that has an equal number of columns and rows.

Arrays can be a cell range. If any of the array cells are empty or contain text then an error is returned.

Remarks

Use the INDEX function to get individual elements from the returned array.

Data Types

Accepts an array. Returns an array.

Examples

MINVERSE(A3:E7)

 

See Also

MDETERM

MMULT