MDETERM Function
Returns the determinant of a square matrix.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice MDETERM in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MDETERM calculates a single number from a square grid of numbers — its determinant.
If the determinant is 0 the matrix has no inverse, which tells you a set of simultaneous equations has no single solution.
Syntax
=MDETERM(array) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | A square range of numbers (same number of rows and columns), with no blanks or text. |
Examples
Example 1 — A 2×2 determinant
For [[3, 8], [4, 6]], the determinant is 3×6 − 8×4.
C1fx=MDETERM(A1:B2)
| A | B | C | |
|---|---|---|---|
| 1 | 3 | 8 | -14 |
| 2 | 4 | 6 |
=MDETERM(A1:B2) Explain
Common mistakes
- Blanks and text. Any empty or text cell in the array returns #VALUE!.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.