November 30, 2023

# How to use the Excel MMULT function

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.
READ:  How to use the Excel LCM function #### Excel

View all posts by Excel →