Exceljet

Quick, clean, and to the point

Excel MDETERM Function

Excel MDETERM function
Summary 

The Excel MDETERM function returns the matrix determinant of a given array. The input array must contain numbers only and be a square matrix, with equal rows and columns. The result is a number representing the matrix determinant.

Purpose 
Get matrix determinant of given array
Return value 
A number representing the matrix determinant
Syntax 
=MDETERM (array)
Arguments 
  • array - A square array of numbers only.
Usage notes 

The MDETERM function returns the matrix determinant of a given array, which must be a square matrix containing numbers only, and no blanks. In mathematics, a determinant using values in a matrix following a specific definition. The result of MDETERM a number representing the matrix determinant. The array argument can be provided as a range or an array constant.

In the example shown, the formula entered across in M7:

=MDETERM(I7:K9)

Which returns a result of 1.

Notes

  1. The input array must be a square matrix with an equal number of rows and columns
  2. The array argument can be provided as a range or array constant like {4,3;3,2}
  3. Empty cells or text in array will cause MDETERM to return a #VALUE! error
  4. MDETERM returns a #VALUE! if array does not have an equal number of rows and columns