Returns the matrix product of two arrays.
Sintaxe
MMULT(array1, array2)Argumentos
array1obrigatório
The first matrix to multiply.
array2obrigatório
The second matrix to multiply.
The MMULT function calculates the product of two matrices. The number of columns in array1 must be equal to the number of rows in array2, and both arrays must contain only numbers.
=MMULT({1,2;3,4}, {5,6;7,8})→{19, 22; 43, 50}Multiplies a 2x2 matrix by another 2x2 matrix.
Select the output range
Highlight a range of cells that matches the dimensions of the resulting matrix.
Enter the formula
Type =MMULT(array1, array2) and press Ctrl+Shift+Enter if using older Excel versions.
This usually happens if the number of columns in the first array does not match the number of rows in the second array.