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

ArgumentRequired?What it does
arrayYesA 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)
ABC
138-14
246
=MDETERM(A1:B2) Explain

Common mistakes

  • Blanks and text. Any empty or text cell in the array returns #VALUE!.

Notes

Kyle Stott

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.