# MDETERM

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.microsoft.com* For the Google documentation refer to support.google.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!