MMULT

Returns the matrix product of the specified arrays.

Syntax

MMULT( ReferenceOrArray array1, ReferenceOrArray array2 ) → Array

Parameters

array1

Required. The first array to multiply.

array2

Required. The second array to multiply.

Remarks

The specified parameters must be arrays or cell references. The number of columns in array1 must be the same as the number of rows in array2. Otherwise, the function returns #VALUE!. The result is an array with the same number of rows as array1 and the same number of columns as array2.

Example

Formula

=MMULT(A1:B4,C1:F2)
=MMULT({1;2},{3|4})

See Also

Function Reference
MUNIT Function