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

MINVERSE(array)

 
 Returns the inverse matrix of an array.

 arrayThe array of numbers, with the same number of rows and columns.

 REMARKS
 
  		• This function can return an array.
     
  		• The "array" can be a cell range, or an array constant, such as {1,2;3;4}.
     
  		• If the array does not have an equal number of rows and columns, then #VALUE! is returned.
     
  		• If any cells in array are empty or contain text, then #VALUE! is returned.
     
  		• The product of a matrix and its inverse is the identity matrix, which is the square array in which the diagonal values are 1, and all other values are 0.
     
  		• If the square matrix cannot be inverted, then #NUM! is returned.
     
  		• The determinant for a non invertible matrix is 0.
     
  		• This function is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the cancellation is not complete.
     
  		• For a working example please refer to the Matrix Functions page.

     EXAMPLES
     
     A
    1=MINVERSE({3}) = 0.333
    2=MINVERSE({0.3333}) = 3
    3{=MINVERSE({4,2;1,3}) } = {0.3.-0.2;-0.1,0.4}
    4{=MINVERSE({4,2,3;1,3,4;2,4,6}) } = {0.3,0,-0.2;0.3,3,-2.2;-0.3,-2,1.7}
    5=MINVERSE({10,20,30,40}) = #VALUE!
    		 
     Functions - M | Index - M | Office Online 

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