MMULT Function Explained
The MMULT Function in Microsoft Excel multiplies two matrices and returns the result as a matrix. It takes two arguments: an array of numbers (the first matrix) and another array of numbers (the second matrix). The two matrices must have the same number of columns in the first matrix as the number of rows in the second matrix. The result of the MMULT Function is a matrix with the same number of rows as the first matrix and the same number of columns as the second matrix.
MMULT Function Syntax
MMULT(array1, array2)
- array1: A range of cells or an array constant.
- array2: A range of cells or an array constant.