In order for MINVERSE to calculate an inverse matrix,arraymust contain numbers only.
When an inverse exists, MINVERSE returns an inverse matrix with the same dimensions as thearrayprovided.
If a matrix cannot be inverted, MINVERSE will return a #NUM!
A matrix that can’t be inverted has adeterminantof zero (0).
Array syntax
The MINVERSE function returns anarrayof values.
The result from MMULT is anarraythat contains the same number of rows asarray1and the same number of columns asarray2.
This resulting matrix contains ones on the main diagonal and zeros in every other position.
MDETERM Function
The Excel MDETERM function returns the matrix determinant of a given array.
The input array must contain numbers only and be a square matrix, with equal rows and columns.
The result is a number representing the matrix determinant.
