MMULTCalculates 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 for matrix2
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.
Examples