MMULT


Definition

Calculates the matrix product of two matrices specified as arrays or ranges.

Sample Usage

 

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: Calculates the sum of the products of corresponding entries in two equal-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.

In order to use the MMULT formula, start with your edited Excellentable:

image2016-7-14 15:38:46.png

  

image2016-7-14 15:38:18.png