MMULT

Syntax:

MMULT ( array-1 , array-2 )

Description: Computes the product of the matrices of numbers designated by array-1 and array-2.

Mathematical Formula:

The matrix product array a of two arrays b and c is:

where i is the row number, and j is the column number.

Arguments:

Name	Type	Description
array-1	array, reference, name	Designate the matrices of numbers to be multiplied.
array-2	array, reference, name	Designate the matrices of numbers to be multiplied.

Return Type and Value: number – The product of the matrices of numbers designated by array-1 and array-2.

However, if

Any cells in array-1 or array-2 are empty or contain text, the return value is unspecified.
The number of columns in array-1 is different from the number of rows in array-2, #VALUE! is returned.

example: