Check Sheet Logo
Check Sheet

MMULT

The MMULT formula in Google Sheets multiplies two matrices together and returns the resulting matrix. It is commonly used in linear algebra for matrix multiplication.

Usage

Use the MMULT formula with the syntax shown below, it has 2 required parameters:

=MMULT(matrix1, matrix2)
Parameters:
  1. matrix1 (required):
    The first matrix to be multiplied. Must contain at least one row and one column.
  2. matrix2 (required):
    The second matrix to be multiplied. Must have the same number of rows as the number of columns in matrix1.

Examples

Here are a few example use cases that explain how to use the MMULT formula in Google Sheets.

Multiply two matrices

The 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.

Common Mistakes

MMULT not working? Here are some common mistakes people make when using the MMULT Google 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.

Related Formulas

The following functions are similar to MMULT or are often used with it in a formula:

  • SUMPRODUCT

    The SUMPRODUCT formula 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.

  • TRANSPOSE

    The TRANSPOSE formula 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.

  • MINVERSE

    The MINVERSE function 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.

Learn More

You can learn more about the MMULT Google Sheets function on Google Support.