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

MMULT(array1, array2)

 
 Returns the matrix product of two arrays.

 array1The first array.
 array2The second array.

 REMARKS
 
  		• This function can return an array.
     
  		• "array1" and "array2" are the arrays you want to multiply.
     
  		• The number of columns in "array1" must be the same as the number of rows in "array2", and both arrays must contain only numbers.
     
  		• The result is an array with the same number of rows as "array1" and the same number of columns as "array2".
     
  		• "array1" and "array2" can be given as cell ranges, array constants, or references.
     
  		• If any cells are empty or contain text, then #VALUE! is returned.
     
  		• If the number of columns in "array1" is different from the number of rows in "array2", then #VALUE! is returned.
     
  		• For a working example please refer to the Matrix Functions page.

     EXAMPLES
     
     ABC
    1=MMULT({3},{4}) = 1224
    2=MMULT(B1,B2) = 842
    3{=MMULT(B1:C2,B1:C2)} = { {20,16},{16,20} }  
    4{=MMULT({1,3;7,2}, {2,0;0,2}) } = { {2,6},{14,4} }  
    		 
     Functions - M | Index - M | Office Online 

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