You can use this function in your Excel worksheet by calling the MatrixMultiplication function and passing the two matrices as arguments. Result(i, j) = result(i, j) + matrix1(i, k) * matrix2(k, j) ReDim result( 0 To UBound(matrix1, 1), 0 To UBound(matrix2, 2)) MatrixMultiplication = 'Error: Matrices cannot be multiplied' If (UBound(matrix1, 2) UBound(matrix2, 1)) Then ' Check if the number of columns in matrix1 matches the number of rows in matrix2 Here's an example of how you can write a function to multiply two matrices in VBA:įunction MatrixMultiplication(matrix1 As Variant, matrix2 As Variant) As Variant You can perform matrix multiplication in Microsoft Excel using Visual Basic for Applications (VBA) code. This is how multiplied matrix looks like. This is an array formula so press CTRL + SHIFT + ENTER keyboard shortcut. MMULT formula in my example is =MMULT(A2:B3,D2:F3) To use it, highlight the whole matrix and type formula in first cell. The result of the formula will be placed in the top-left cell of the resulting array, and the rest of the cells in the array will be automatically filled in. Argumentsįor example, if you have two arrays, A1:B2 and C1:D2, you can multiply these arrays with the following formula: MMULT function takes arrays as arguments so it is obvious to use. We will use MMULT Excel function for matrix multiplication. Then you need to use MMULT Excel function to multiply given arrays. The numbers of columns of matrix A and rows of matrix B do not matter at all. The calculation is possible because the number of rows of matrix A is the same as the number of columns of matrix B. It will have the size of the number of rows in matrix A and the number of columns in matrix B.

Once we have the appropriate 2 matrices, what can we expect the resulting matrix (matrix C).

To be able to multiply the first matrix (let's call it matrix A) needs to have the same number of rows as the number of columns of the second matrix (let's call it matrix B).There are a few rules to follow when you multiply matrices.

For our case matrixes have to contain just numbers. Matrices play a particularly important role in computer science and statistics, where huge data sets are often present. They are used to save large data sets that are in a relationship to each other. You see how to use MMULT Excel function to multiply matrixes.Ī matrix is a rectangular array of numbers, symbols, and expressions arranged in rows and columns. In this Excel tutorial you teach yourself about matrix multiplication in Excel.

How to use mmult in excel with macros