Excel MMULT, a “Math & Trigonometry” function in excel, stands for “Matric Multiplication” and returns the product of two arrays of two matrices where the number of rows of Matrix 1 is equal to the number of columns of Matrix 2.
Syntax: MMULT(array1, array2)
The MMULT function syntax has the following arguments:
- array1: An array of numbers that must have the same number of columns as the number of rows in array2.
- array2: An array of numbers that must have the same number of columns as the number of rows in array1.
Example: Let’s look at some Excel MMULT function examples and explore how to use the MMULT function as a worksheet function in Microsoft Excel:
Example 1:
In this example for Matrix 1, we have two rows and for Matrix 2 we have two columns, so Matrix 3 will be 2 * 2 matrix. So select 2 * 2 rows and columns to create new Matrix 3.
Syntax: =MMULT(A2:C3,E2:F4)
Result:
Example 2:
This time we have 3 * 3 matrix, so new matrix will be the number of rows of Matrix 1 and number of columns of Matrix 2. So new Matrix 3 will also be 3 * 3 matrix only.
Syntax: =MMULT(A2:C4,E2:G4)
Result:
Note:
- Arrays must contain only numbers.
- Columns in array1 must equal the rows in array2.
- Array1 and Array2 can be provided as cell ranges, array constants, or references.
- Formulas that return arrays must be entered as array formulas using control + shift + enter.
- MMULT returns the #VALUE! error if any cells in array1 and array2 are not numbers, or if array1 columns do not equal array2 rows.