MMULT

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: