This function returns the matrix product for two arrays.

Syntax

MMULT(array1,array2)

Arguments

The arrays are numeric arrays where the columns in array1 match the rows in array2.

Arrays can be a cell range. If any of the array cells are empty or contain text then an error is returned.

Remarks

Use the INDEX function to get individual elements from the returned array.

Data Types

Accepts an array for all arguments. Returns an array.

Examples

MMULT(A2:B3,D5:E6)