Excel: Mmult Function
In Excel, the Mmult function returns the matrix product of two arrays.
The syntax for the Mmult function is:
Mmult( array1, array2 )
array1is an array of numbers. array1 must have the same number of columns as the number of rows in array2.
array2is an array of numbers. array1 must have the same number of columns as the number of rows in array2.
Note:
If any of the cells in the array contain empty or non-numeric values, the Mmult function will return the #VALUE! error.
If the array1 does not contain the same number of columns as the number of rows in array2, the Mmult function will return the #VALUE! error.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Mmult(A1:B2, A5:B6) would return 6.23 =Mmult(A1:C3, A5:C7) would return #VALUE! =Mmult({1,2;3,4},{5,6;7,8}) would return 19