The unit matrix is also called the identity matrix.
The MUNIT function takes just one argument,dimension, which should be a positive integer.
The resulting matrix contains ones on the main diagonal and zeros in every other position.
The result from MMULT is anarraythat contains the same number of rows asarray1and the same number of columns asarray2.
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.
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.
