Excel functions / Math

MDETERM function

The determinant of a square matrix.

Syntax

=MDETERM(array)

Arguments

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

  1. A 2 × 2 determinant

    ABCD
    138-14
    246

    In D1: =MDETERM(A1:B2) → -14

    3 × 6 minus 8 × 4.

    Try this example

  2. A matrix with no inverse

    ABCD
    1120
    224

    In D1: =MDETERM(A1:B2) → 0

    Try this example

Common mistakes

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.

Translate a whole formula

Try MDETERM in the playground

Related functions