Returns the matrix determinant of an array.

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

* 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
* For the Google documentation refer to

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!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top