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:

**Related:** An Introduction to (2×2) by (2×2) Matrix Multiplication

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

**Related:** An Introduction to (2×2) by (2×3) Matrix Multiplication

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

**Related:** An Introduction to (3×3) by (3×2) Matrix Multiplication

**Note**: You can find the complete documentation for the **MMULT** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Use a MULTIPLY IF Function in Excel

How to Multiply Column by a Percentage in Excel

How to Multiply Column by a Constant in Excel