Calculates the matrix product of two matrices specified as arrays or ranges.
Sample Usage
MMULT(A1:B3,C1:F2)
MMULT({1,2,3;4,5,6},{7;8;9})
Syntax
MMULT(matrix1, matrix2)
matrix1
- The first matrix in the matrix multiplication operation, represented as an array or range.matrix2
- The second matrix in the matrix multiplication operation, represented as an array or range.
Notes
- As standard in matrix multiplication, the number of columns for
matrix1
must equal the number of rows formatrix2
See Also
TRANSPOSE: Transposes the rows and columns of an array or range of cells.
SUMPRODUCT: The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.
MINVERSE: Returns the multiplicative inverse of a square matrix specified as an array or range.
MDETERM: Returns the matrix determinant of a square matrix specified as an array or range.