MINVERSE Function in Google Sheets

Calculate the inverse of a square matrix using the MINVERSE function.

MINVERSE Function

The MINVERSE function in Google Sheets calculates the inverse of a square matrix.

Syntax

MINVERSE(square_matrix)
  • square_matrix: A range or array representing a square matrix.

Examples

  1. Basic Example

Calculate the inverse of a 2x2 matrix in range A1:B2:

=MINVERSE(A1:B2)

Notes

  • The matrix must be square and non-singular.
  • MDETERM: Calculate the determinant of a matrix.