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 1E16. * 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 

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