MMULTformula in Google Sheets multiplies two matrices together and returns the resulting matrix. It is commonly used in linear algebra for matrix multiplication.
- How to use
- Examples of using
MMULTformula not working?
- Similar formulas to
MMULT formula with the syntax shown below, it has 2 required parameters:
- matrix1 (required):
The first matrix to be multiplied. Must contain at least one row and one column.
- matrix2 (required):
The second matrix to be multiplied. Must have the same number of rows as the number of columns in matrix1.
ExamplesHere are a few example use cases that explain how to use the
MMULTformula in Google Sheets.
Multiply two matrices
MMULT formula can be used to multiply two matrices together and return the resulting matrix.
Calculate linear transformations
Linear transformations can be represented using matrices, and the
MMULT formula can be used to calculate the resulting matrix of applying multiple linear transformations to a vector.
MMULTnot working? Here are some common mistakes people make when using the
MMULTGoogle Sheets Formula:
Incorrect matrix dimensions
One of the most common mistakes when using the MMULT formula is providing matrices with incorrect dimensions. The number of columns of the first matrix must match the number of rows of the second matrix. Double-check your matrices' dimensions and adjust them if necessary.
Not using curly braces to input matrices
When inputting matrices, make sure to enclose them in curly braces and separate rows by semicolons. Avoid using parentheses or brackets, as they will not work with the MMULT formula.
Using non-numeric values
The MMULT formula only works with numeric values. Make sure your matrices contain only numbers and avoid using any other characters or symbols.
Forgetting to specify both matrices
The MMULT formula requires two matrices as inputs. Make sure you have specified both matrices and that they are separated by a comma.
Incorrect order of matrices
The order of matrices matters for the MMULT formula. The first matrix should be the one with the same number of columns as the second matrix's number of rows. Double-check that you have entered the matrices in the correct order.
The following functions are similar to
MMULT or are often used with it in a formula:
SUMPRODUCTformula in Google Sheets multiplies corresponding values in the specified arrays and returns the sum of those products. It is commonly used to find the weighted average or to perform a dot product calculation.
TRANSPOSEformula in Google Sheets allows you to flip a table of data by turning rows into columns and columns into rows. This can be useful for reorganizing data or preparing it for use in other formulas.
MINVERSEfunction in Google Sheets returns the inverse matrix of a given square matrix. The inverse matrix is such that when multiplied by the original matrix, it results in an identity matrix. This function is commonly used in linear algebra, such as solving systems of linear equations or finding determinants of matrices.
You can learn more about the
MMULT Google Sheets function on Google Support.