MDETERM function
MDETERM returns the determinant of a square matrix as a single number. It is used to test whether a system of equations has a unique solution.
Example
Read it as a sentence: find the determinant of the 2 by 2 grid in F1:G2, which gives -2.
Excel shows -2
F
G
1
1
2
2
3
4
Data
Syntax
MDETERM(array)
-
array(required) - A square numeric array or range with equal rows and columns.
Returns: The determinant of the matrix, a single number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=MDETERM({1,2;3,4}) | -2 | Array constant |
=MDETERM(5) | 5 | Single number |
=MDETERM(Data!F1:G2) | -2 | 2x2 |
=MDETERM(Data!H1:I2) | 0 | Singular |
=MDETERM("5") | #VALUE! | Text number |
=MDETERM(Data!J1:L2) | #VALUE! | Non-square |
=MDETERM(Data!F4:G5) | #VALUE! | Text in matrix |
=MDETERM(Data!D1:D1) | #VALUE! | Blank matrix |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
F
G
H
I
J
K
L
1
1
2
1
2
1
2
3
2
3
4
2
4
4
5
6
3
4
1
2
5
x
4
Data
Watch out for
- Non-square or non-numeric input returns #VALUE!.
- Results can show tiny rounding errors.
Where it works
- Excel
- MDETERM is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .