MDETERM
Syntax:
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.
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: