Syntax: DET(M)
M = a range, which must contain an equal number of rows and columns.
DET returns the determinant of the matrix specified by the range M, which must be square.
Examples:
Matrix A1..C3 =
A | B | C | |
1 | 1 | 2 | 6 |
---|---|---|---|
2 | 3 | 4 | 11 |
3 | 4 | 7 | 2 |
DET(A1..C3) = 37
DET(A1..B3) = Error - DET, matrix must be square
Excel function: N/A