MINVERSE

The MINVERSE function returns the inverse matrix of a given array. The product of a matrix and its inverse is the identity matrix, a n × n square matrix with ones on the main diagonal and zeros in every other position. The MINVERSE function takes just one argument, array, which should be a square matrix, with an equal number of rows and columns. In order for MINVERSE to calculate an inverse matrix, array must contain numbers only. When an inverse exists, MINVERSE returns an inverse matrix with the same dimensions as the array provided. If a matrix cannot be inverted, MINVERSE will return a #NUM! error. A matrix that can't be inverted has a determinant of zero (0). In the example shown the formula used in E7 to calculate the inverse matrix of the 2 x 2 matrix in the range B7:C8 is: The resu