MINVERSE

Returns 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

Was this helpful?
How can we improve it?