WorksheetFunction.MMult Method
Office 2007
| Excel Developer Reference |
Syntax
expression.MMult(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 - Arg2 | Required | Variant | Array1, array2 - the arrays you want to multiply. |
Return Value
Variant
Remarks
The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers.
- Array1 and array2 can be given as cell ranges, array constants, or references.
- MMULT returns the #VALUE! error when:
- Any cells are empty or contain text.
- The number of columns in array1 is different from the number of rows in array2.
- The size of the resulting array is equal to or greater than a total of 5,461 cells.
- The matrix product array a of two arrays b and c is:
where i is the row number, and j is the column number.
- Formulas that return arrays must be entered as array formulas.
