MMULT()

Syntax. MMULT(array1,array2)

Definition. This function returns the product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.

Arguments

  • array1 (required) and array2 (required) The arrays you want to multiply

Background. The arguments array1 and array2 can be any of the following:

  • A cell range (such as A1:C3)

  • An array constant (such as {1.2.3;4.5.6;7.8.9})

  • A name for the cell range or the array constant

To allow the calculation of the product of two arrays, the number of columns in array1 must be the same as the number of rows in array2. Both arrays only can contain numbers.

To calculate the product, the row elements of the first array are multiplied with the column elements of ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.