Table of Contents
The MMULT function in Excel is a built-in mathematical function that allows users to multiply two matrices together. It is typically used in data analysis and manipulation to perform various calculations and transformations on sets of data. To use the MMULT function, users must first input the two matrices they want to multiply into separate cells in Excel. Then, they can input the MMULT function into a designated cell and reference the cells containing the two matrices as its arguments. Once the function is entered, it will calculate and display the resulting matrix in the designated cell. The MMULT function is a useful tool for performing complex mathematical operations and can save users time and effort in data analysis.
The MMULT function returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.
Note: If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it. Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.
Syntax
MMULT(array1, array2)
The MMULT function syntax has the following arguments:
array1, array2 Required. The arrays you want to multiply.
Remarks
The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers.
Array1 and array2 can be given as cell ranges, array constants, or references.
MMULT returns the #VALUE! error when:
Any cells are empty or contain text.
The number of columns in array1 is different from the number of rows in array2.
The matrix product array a of two arrays b and c is:
where i is the row number, and j is the column number.
Examples
Example 1
Example 2
You must enter the above formulas as array formulas for it to work correctly. After you enter the formula, press Enter if you have a current Microsoft 365 subscription; otherwise press Ctrl+Shift+Enter. If the formula is not entered as an array formula, a single result is returned.
Cite this article
stats writer (2024). How do I use the MMULT function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-mmult-function-in-excel/
stats writer. "How do I use the MMULT function in Excel?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-mmult-function-in-excel/.
stats writer. "How do I use the MMULT function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-mmult-function-in-excel/.
stats writer (2024) 'How do I use the MMULT function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-mmult-function-in-excel/.
[1] stats writer, "How do I use the MMULT function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the MMULT function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.