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 the second array.

Example. See the example for the MINVERSE() function.

See Also

MDETERM(), MINVERSE(), TRANSPOSE()

Sample Files

Use the ARRAY_FUNCTION or ARRAY_FUNCTION2 worksheets in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.