MDETERM(array)

Returns the matrix determinant of an array.

arrayThe 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!


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