MDETERM Function in Google Sheets

Calculate the determinant of a square matrix using the MDETERM function.

MDETERM Function

The MDETERM function in Google Sheets calculates the determinant of a square matrix.

Syntax

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

Examples

  1. Basic Example

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

=MDETERM(A1:B2)

Notes

  • The matrix must be square (same number of rows and columns).
  • MINVERSE: Calculate the inverse of a matrix.