Articles with the tag:
Articles with the tag:
Try in the cloud

MMULT Function

The MMULT function is one of the math and trigonometry functions. It is used to return the matrix product of two arrays and display the first value of the returned array of numbers.


MMULT(array1, array2)

The MMULT function has the following arguments:

Argument Description
array1, array2 An array of numbers.


If any of the cells in the array contain empty or non-numeric values, the function will return the #N/A error.

If the number of columns in array1 is not the same as the number of rows in array2, the function will return the #VALUE! error.

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the MMULT function.


The figure below displays the result returned by the MMULT function.

MMULT Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action