Description
MDETERM function returns the determinant of a given matrix.
If the @matrix does not contain equal number of columns and rows, MDETERM returns #VALUE! error.
This function is Excel compatible.
Examples
Let us assume that A1, ..., A4 contain numbers 2, 3, 7, and 3, B1, ..., B4 4, 2, 4, and 1, C1, ..., C4 9, 4, 3, and 2, and D1, ..., D4 7, 3, 6, and 5. Then
MDETERM(A1:D4) equals 148.