This function returns the matrix determinant of an array.

Syntax

MDETERM(array)

Arguments

The array is a numeric array that has an equal number of columns and rows.

Arrays can be a cell range. If any of the array cells are empty or contain text then an error is returned.

Data Types

Accepts an array. Returns numeric data.

Examples

MDETERM(A3:E7)