MINVERSE function

The MINVERSE function is one of the math and trigonometry functions. It is used to return the inverse matrix for a given matrix and display the first value of the returned array of numbers.

Syntax

MINVERSE(array)

The MINVERSE function has the following argument:

Notes

If any of the cells in the array contain empty or non-numeric values, the function will return the #N/A error.

If the number of rows in the array is not the same as the number of columns, the function will return the #VALUE! error.

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the MINVERSE function.

Examples

The figure below displays the result returned by the MINVERSE function.