The determinant is a special number that can help characterize some properties of the matrix.
For example, if the determinant is zero, the matrix will not have an inverse.
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.
MINVERSE Function
The Excel MINVERSE function returns the inverse matrix of a given array.
The input array must contain numbers only and be a square matrix, with equal rows and columns.
The result is an inverse matrix with the same dimensions as the array provided.
