MMULT Function in Excel – Product or multiplication of matrices in Excel

MMULT Function in Excel calculates the multiplication or product of two matrices

Syntax of MMULT Function in Excel

MMULT( array1,array2 ) 

Where array1 and array2 are array of numeric values, that represent a square matrix (i.e. has the same number of rows and columns).

Example of MMULT Function in Excel

Let’s see how to calculate the product of two matrices using MMULT Function step by step (we will be using two 3×3 matrices as an example).

Step 1: Select 3X3 Cells where you want to calculate the product of two matrices as shown below

MMULT Function in Excel 1

Step 2: In the formula section specify MMULT Function and supply two matrices as input in the form of array  i.e. =MMULT(A2:C4,F2:H4)

MMULT Function in Excel 2

Step 3: press Ctrl+Shift+Enter to get the product of two matrices

MMULT Function in Excel 3

So the resultant matrix will be

MMULT Function in Excel 4

previous-small MMULT Function in Excel                                                                                                                next_small MMULT Function in Excel