Excel MDETERM Function

Using the Excel MDETERM Function

Excel MDETERM Function

Summary

The Excel MDETERM function returns the matrix determinant of an array. The input array must have equal rows and columns (a square matrix) and only contain numbers.

Syntax

=MDETERM (array)

Syntax Breakdown

Array
Required. An array consisting of number with equal number of rows and columns. The array argument can be provided as a range or an array constant, such as {1,2;3,4;5,6}.

Usage Notes

MDETERM returns the matrix determinant of an array that is a square matrix containing only numbers. The function will return the #VALUE! error if the array contains empty cells or text. The #VALUE! error is also returned if the array argument does not contain an equal number of rows and columns.