The MDETERM function takes just one argument, array, which can be provided as a range or an array constant. Array must be a square matrix with the same numbers of rows and columns.
Examples
To get the matrix determinant for the 2 x 2 array shown in B7:C8, the formula in E7 is: The equivalent formula with an array constant is: To get the matrix determinant for the 3 x 3 array shown in I7:K9, the formula in M7 is: The equivalent formula with an array constant is:
Notes
The array argument must be a square matrix with an equal number of rows and columns The array argument can be provided as a range or array constant like {4,3;3,2} Empty cells or text in array will cause MDETERM to return a #VALUE! error MDETERM returns a #VALUE! if array does not have an equal number of rows and columns
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
