Skip to content
Excel

MDETERM function in Excel

Returns the matrix determinant of an array

=MDETERM(array)

MDETERM syntax and parameters

One argument, one required.

  • arrayarrayRequired

    A numeric array with an equal number of rows and columns.

MDETERM examples

Formulas you'll actually reuse.

  1. The determinant of a 3×3 matrix — 0 means it can't be inverted:

    =MDETERM(B2:D4)

    Result-12

  2. Check a system of equations before calling MINVERSE:

    =IF(MDETERM(B2:D4) = 0, "No unique solution", "Solvable")

    Result"Solvable"

MDETERM in Google Sheets

Same name — your formula ports as-is.

Try MDETERM in the playground

Edit the example — nothing to install.

Preloaded with the MDETERM formula from Example 1 — change anything and watch it respond.

Loading the editor…

MDETERM errors

What they mean — and the fixes.

  • #VALUE!

    The range isn't square, or a cell is empty or text.

Related functions

More ways Excel gets this done.