Excel functions / Math
MDETERM function
The determinant of a square matrix.
Syntax
=MDETERM(array)
Arguments
array: A square matrix of numbers.
When to use it
MDETERM gives the determinant of a square matrix. A determinant of 0 means the matrix has no inverse, so a set of equations written with it has no single solution.
Examples
A 2 × 2 determinant
A B C D 1 3 8 -14 2 4 6 In D1:
=MDETERM(A1:B2)→ -143 × 6 minus 8 × 4.
A matrix with no inverse
A B C D 1 1 2 0 2 2 4 In D1:
=MDETERM(A1:B2)→ 0
Common mistakes
- Not square. The matrix needs as many rows as columns, or the result is #VALUE!.
MDETERM in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DETERMINANT
- Danish: MDETERM
- Dutch: DETERMINANTMAT
- Finnish: MDETERM
- French: DETERMAT
- German: MDET
- Hungarian: MDETERM
- Italian: MATR.DETERM
- Norwegian: MDETERM
- Polish: WYZNACZNIK.MACIERZY
- Portuguese (Brazil): MATRIZ.DETERM
- Portuguese (Portugal): MATRIZ.DETERM
- Russian: МОПРЕД
- Spanish: MDETERM
- Swedish: MDETERM
- Turkish: DETERMİNANT