Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > MDETERM
 

MDETERM(array)

 
 Returns the matrix determinant of an array.

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

 REMARKS
 
  		• 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.
     
  		• 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.
     
  		• For a working example please refer to the Matrix Functions page.

     EXAMPLES
     
     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!
    		 
     Functions - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top