MS Excel: Mdeterm Function
In Excel, the Mdeterm function returns the matrix determinant of an array.
The syntax for the Mdeterm function is:
Mdeterm( array )
array is an array of numbers. The array must have the same number of rows as the number of columns.
Note:
If any of the cells in the array contain empty or non-numeric values, the Mdeterm function will return the #VALUE! error.
If the array does not contain the same number of rows as the number of columns, the Mdeterm function will return the #VALUE! error.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Mdeterm(A1:B2) would return 1.81 =Mdeterm(A1:C3) would return #VALUE! =Mdeterm({1,2;3,4}) would return -2 =Mdeterm({1,2,1;3,4,2;1,1,2}) would return -3