3x3 matrix multiplication calculation

Use our calculadora para multiplicar matrices 3x3 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 multiplicaciones de matrices 3x1 o 3x2. You only have to leave the data in the corresponding column empty and that's it.

Si quieres asegurarte de que has multiplicado bien dos matrices 3x3 o quieres aprender cómo se hace el producto de dos matrices 3x3, read on and we will answer your questions.



 

Cómo se multiplican matrices 3x3

Multiplying 3x3 matrices

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 ejemplo en el que se puede ver cómo se multiplican matrices 3x3:

Example of multiplication of fractions 3x3

Multiplicar matrices 3x3 en Excel

You can also multiplicar matrices 3x3 en 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:

  • 3x3 por 3x1
  • 3x3 por 3x2
  • 3x3 por 3x3

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:

=MMULT(B5:D7;F5:H7)

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.

Leave a Comment

Information on data protection

  • Responsible: Ignacio Cuesta
  • Purpose of processing: Spam control, comment management, etc.
  • Legitimation: Your consent
  • Communication of data: Data will not be communicated to third parties except by legal obligation.
  • Rights: Access, rectification, portability, forgetfulness.
  • Contact us: contacto@calculadoraconversor.com.
  • Additional information: More information at our privacy policy.