ExcelFlux

MDETERM function

the matrix determinant of an array.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Check square-matrix determinants. A zero determinant means the matrix has no inverse.

A worked example from the workbook

RowABC
6ABC
7123
8345
9567
Record 1
=MDETERM(A7:B8)

Expected result-2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=MDETERM(A7:B8)
Turkish Excel · tr-TR
=DETERMİNANT(A7:B8)

Worked examples

Check square-matrix determinants. A zero determinant means the matrix has no inverse.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 A B C
7 1 2 3
8 3 4 5
9 5 6 7
Case Formula Expected result
Record 1 =MDETERM(A7:B8) -2
Record 2 =MDETERM(B7:C8) -2
Record 3 =MDETERM(A8:B9) -2
Microsoft Excel reference