Spread Formula Reference
MDETERM
Formula Functions > Functions M to Q > MDETERM

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)

Version Available

This function is available in product version 2.0 or later.

See Also

MINVERSE | MMULT | Math and Trigonometry Functions