Matrices are arrays of numbers. Multiplication of matrices has a wide range of uses in various fields like linear equations, network theory, etc. When two matrices are multiplied, the row elements of a matrix are multiplied with the corresponding column elements of another matrix. It can be a tiresome job to multiply matrices with a higher number of rows and columns manually. Fortunately, matrices can be easily multiplied in Excel. Today, in this article, we’ll learn two quick and suitable ways to multiply 3 matrices in Excel effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
2 Suitable Ways to Multiply 3 Matrices in Excel
We can multiply 3 matrices in Excel by entering a custom formula for each element of the product matrix. But, this may not be advantageous for matrices with higher dimensions. Fortunately, Excel has an inbuilt function named MMULT function to multiply matrices. We will multiply 3 matrices by using the MMULT function. We are going to use the following dataset to illustrate the methods.
1. Use MMULT Function to Multiply 3 Matrices in Excel
The best way to multiply matrices is to use the MMULT function in Excel. To multiply 3 matrices, firstly, you have to multiply the first two matrices. Then multiply the third matrix with the resultant matrix. Let’s follow the instructions below to multiply 3 matrices using the MMULT function!
- Before you attempt to multiply matrices, Make sure the number of columns of the first matrix is equal to the number of rows of the second matrix.
- You need to determine the dimension of the product matrix also. The dimension of a matrix refers to the number of rows and columns of the matrix. The product matrix will have the same number of rows as the first matrix and the same number of columns as the second matrix.
- In the case of our dataset, the dimension of the product matrix will be 3×3.
- Now select cell D10.
- Hence, type the following formula.
- Further, simply press ENTER on your keyboard.
- As a result, you will get the return of the MMULT function.
- Now, we will multiply the Matrix C with the resultant Matrix (AxB) by using the MMULT To do that, write down the MMULT function again in cell H10.
- Again, press ENTER on your keyboard.
- As a result, you will be able to get the multiplication of the 3 matrices’ using the MMULT function.
- How to Create Traceability Matrix in Excel
- Create a Risk Matrix in Excel (With Easy Steps)
- How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)
2. Apply Custom Formula to Multiply 3 Matrices in Excel
This method is not advantageous for multiplying matrices with higher dimensions. Yet, it gives a clear idea of what happens when using the MMULT function. Also, this gives a clear understanding of how to multiply two matrices. Then we will multiply 3 matrices. Let’s follow the instructions below to multiply 3 matrices!
- You can just enter the following formula in cell D10.
- Write down the below formula in cell D11.
- The formula in cell D12 will be
- Furthermore, write down the below formula in cell E10.
- And for cell E11.
- For cell E12.
- Thus, write down the below formula in cell F10.
- In cell F11, we will input this formula.
- Write down the below formula in cell F12.
- This will give the same result obtained in the earlier method. If you just notice the formulas, you can easily understand the process of matrix multiplication.
- You can just enter the following formula in cell H10.
- Similarly, write down the below formula in cell H11.
- Type the below formula in cell H12.
- Enter the below formula in cell I10.
- Input the below formula in cell I11.
- Apply this formula in cell I12.
- The formula in cell J10 is
- Similarly, write down the below formula in cell J11.
- Now, write down the below formula in cell J12.
- Hence, you will get the resultant value of the multiplication of the 3 matrices which has been given in the below screenshot.
Things to Remember
👉 Make sure the number of columns of the first matrix is equal to the number of rows of the second matrix before starting to multiply them.
👉 In Microsoft 365, Excel will show the #Value! Error if you don’t select the proper dimension. The #Value! error occurs when any of the elements of the matrices is not a number.
I hope all of the suitable methods mentioned above to multiply 3 matrices will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.