Excel Function : MMULT

Download now!

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.