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.