# 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:

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.

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.

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