Excel Function : MMULT
Category
Math and trigonometry
Description
Returns the matrix product of two arrays
Microsoft Excel Reference Page
https://support.office.com/en-us/article/MMULT-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb
Syntax and Description of the MMULT Excel Function
The syntax for the MMULT function in Microsoft Excel is: MMULT(array1, array2) array1 is the first array or range of cells to multiply. array2 is the second array or range of cells to multiply.
About MMULT Excel Function
=MMULT(array1,array2) The MMULT function returns the matrix product of two arrays. The matrix product is calculated by multiplying the corresponding entries in the matrices and then summing them.