Use our calculator for 3x3 matrix multiplication online and saves time in this operation which, although is simple to perform, can play a trick on us if we do it quickly.
If you like, you can also use the calculator to make 3×1 or 3×2 matrix multiplications. You only have to leave the data in the corresponding column empty and that's it.
If you want to make sure that you have multiplied two 3×3 matrix correctly or you want to learn how to do the product of two 3×3 matrix, read on and we will answer your questions.
How to multiply 3×3 matrix
For matrix multiplication you must take into account that it is essential that the number of columns of matrix A coincides with the number of rows of matrix B. If this requirement is not met, the matrix cannot be multiplied.
If so, the result will be a matrix with the number of columns of matrix A and the number of rows of matrix B, something that is reflected in the following expression:
Amxn x Bnxp = Cmxp
But,how to multiply matrix? To obtain the element cij of matrix C, what you must do is multiply each element of row i of matrix A by each element of column j of matrix B.
Below you have a example in which you can see how to multiply 3×3 matrix:
3x3 matrix multiplication calculation in Excel
You can also multiplying 3×3 matrix in ExcelYou can even change their dimensions as long as you respect the rule that the number of columns in the first matrix matches the number of rows in the second matrix. This means that we can multiply matrix in this way:
- 3×3 for 3×1
- 3×3 for 3×2
- 3×3 by 3×3
All you have to do is fill in the data for each matrix and when you have done so, select the range of empty cells on which you want the result to be displayed. Once selected, type the following formula:
The range of cells before the semicolon corresponds to cell A and the range of cells after the semicolon are the elements of matrix B.
When you have the formula written down, it is important that you press the keys CTRL + SHIFT (shift) and then the ENTER key to have Excel display the result of the matrix multiplication. If this step is not done, only one element of the resulting matrix will be displayed and not all of them.
If you have any doubts, we recommend that you watch the video above these lines and if you still can't get it, leave us a comment and we will try to help you with the matrix multiplication in Excel.