MINVERSEReturns the multiplicative inverse of a square matrix specified as an array or range.
Sample Usage
MINVERSE(A1:D4)
MINVERSE({1,0,0,0;0,0,4,0;0,1,1,0;0,0,0,1})
Syntax
MINVERSE(square_matrix)
square_matrix – An array or range with an equal number of rows and columns representing a matrix whose multiplicative inverse will be calculated.
See Also
TRANSPOSE: Transposes the rows and columns of an array or range of cells.
MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.
MDETERM: Returns the matrix determinant of a square matrix specified as an array or range.
Examples