Formulas > =MMULT()
How to Use MMULT() in Google Sheets
Description
How To Actually Use MMULT() in Sheets
MMULT(matrix1, matrix2)
Try MMULT yourself
Use the MMULT function to calculate the product of the matrices in ranges A1:B2 and D1:E2. The result should be displayed in the range G1:H2.
Hints (2)
-
Remember that MMULT requires two matrices as input.
-
Ensure the number of columns in the first matrix matches the number of rows in the second matrix.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for MMULT(). Click through to watch.
Learn more about the MMULT() formula:
Generate a MMULT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MMULT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MMULT() formula