# How to Perform Matrix Multiplication in Excel (With Examples)

You can use the MMULT function in Excel to perform matrix multiplication.

This function uses the following basic syntax:

MMULT(array1, array2)

where:

• array1, array2: The two matrices you’d like to multiply.

The following examples show how to use the MMULT function to perform the following matrix multiplications in Excel:

• (2×2) by (2×2) Matrix Multiplication
• (2×2) by (2×3) Matrix Multiplication
• (3×3) by (3×2) Matrix Multiplication

Let’s jump in!

## Example 1: (2×2) by (2×2) Matrix Multiplication

The following screenshot shows how to multiply a (2×2) matrix with another (2×2) matrix in Excel: We typed the following formula in cell G2 to perform this matrix multiplication:

```=MMULT(A2:B3, D2:E3)
```

Here are the actual formulas that Excel used to perform this matrix multiplication: This results in the following 2×2 matrix: ## Example 2: (2×2) by (2×3) Matrix Multiplication

The following screenshot shows how to multiply a (2×2) matrix with a (2×3) matrix in Excel: We typed the following formula in cell H2 to perform this matrix multiplication:

```=MMULT(A2:B3, D2:F3)
```

Here are the actual formulas that Excel used to perform this matrix multiplication: This results in the following 2×3 matrix: ## Example 3: (3×3) by (3×2) Matrix Multiplication

The following screenshot shows how to multiply a (3×3) matrix with a (3×2) matrix in Excel: We typed the following formula in cell H2 to perform this matrix multiplication:

```=MMULT(A2:C4, E2:F4)
```

Here are the actual formulas that Excel used to perform this matrix multiplication: This results in the following 3×2 matrix: Note: You can find the complete documentation for the MMULT function in Excel here.