Formulas and Functions
MDETERM
The MDETERM function returns the determinant of a matrix. The determinant is a single numerical value calculated from a square matrix.
MDETERM(matrix)
matrix: A numeric array with an equal number of rows and columns.
Notes
MDETERM will return an error if the number of rows is not equivalent to the number of columns.
Examples |
|---|
Given the following matrix: |
A | B | C | |
|---|---|---|---|
1 | 5 | 3 | 7 |
2 | 6 | 9 | 2 |
3 | 1 | 8 | 3 |
=MDETERM(A1:C3) returns 280. =MDETERM(A1:B2) returns 27. =MDETERM(A1:C2) returns an error because there is not an equal number of rows and columns. |