### MDETERM(array)

Returns the matrix determinant of an array.

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

#### Remarks

 * For an illustrated example refer to the Matrix Category page.* Array can be given as a cell range, for example, A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name to either of these.* If any cells in array are empty or contain text, then #VALUE! is returned.* The function will also return #VALUE! if "array" does not have an equal number of rows and columns.* If any of the arguments are not numeric, then #VALUE! is returned.* A matrix with m rows and n columns is said to be of order m*n and when m and n are equal the matrix is said to be a square.* Matrix determinants are generally used for solving systems of mathematical equations that involve several variables.* This function is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the calculation is not complete.* For example, the determinant of a singular matrix may differ from zero by 1E-16.* You can use the MINVERSE function to return the inverse matrix of an array.* You can use the MMULT function to return the matrix product of two arrays.* You can use the TRANSPOSE function to returns an array with its orientation changed.* For the Microsoft documentation refer to support.office.com

 A 1 =MDETERM({1,3,8,5;1,3,6,1;1,1,1,0;7,3,10,2}) = 88 2 =MDETERM({3,6,1;1,1,0;3,10,2}) = 1 3 =MDETERM({3,6;1,1}) = -3 4 =MDETERM({1,3,8,5;1,3,6,1}) = #VALUE!