MDETERM Function Explained

The MDETERM Function in Microsoft Excel calculates the matrix determinant of an array. It takes a single argument, which is a square array of numeric values. The function returns the determinant of the array, which is a single number. The determinant is a measure of the size and sign of the matrix.

MDETERM Function Syntax

MDETERM(matrix)

  • matrix: A required argument. It is a range of cells that contains the array or matrix for which you want to calculate the matrix determinant.