MMULT Function in Excel calculates the multiplication or product of two matrices
Syntax of MMULT Function in Excel
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
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)
Step 3: press Ctrl+Shift+Enter to get the product of two matrices
So the resultant matrix will be