MDETERM ( array )

Description: Computes the determinant of the square matrix of numbers designated by array. The determinant is calculated with an accuracy of at least 15 digits, which can lead to a small numeric error when the calculation is not complete. [Example: The determinant of a singular matrix can differ from zero by 1E-16. end example]

Arguments:

Name	Type	Description
array	array, reference	Designate a square matrix of numbers.

Return Type and Value: number – The determinant of array. Some square matrices cannot be inverted. The determinant of a non-invertible matrix is 0.

However, if

• Any cells in array are empty or contain text, the return value is unspecified.

• The matrix designated by array is not square, #VALUE! is returned.

[Example:

MDETERM(A2:D5) results in the determinant of the 4x4 array designated by the cell range
MDETERM({3,6,1;1,1,0;3,10,2}) results in 1
MDETERM({3,6;1,1}) results in -3

end example]