This tutorial explains how to find **the inverse of a matrix** in Excel.

**Finding the Inverse of a Matrix**

To find the inverse of a matrix in Excel, we only need to use one function: **MINVERSE**. This function returns the inverse of a matrix uses the following syntax:

**MINVERSE(x)**

where **x **is the matrix we wish to find the inverse for.

The following examples illustrate how to find the inverse of matrices of various sizes.

**Finding the Inverse of a 2×2 Matrix**

Suppose we have a **2×2 **matrix C, which has 2 rows and 2 columns:

Here is how to find the inverse of this matrix in Excel:

**Step 1: Enter the data values for the matrix. **

**Step 2: Find the inverse of the matrix.**

- First, highlight a 2×2 group of cells where the output will go. For example, highlight cells
**E2:F3**. - With the cells highlighted, type in
**=MINVERSE(B2:C3)**, then click**Ctrl+Shift+Enter**.

The following results will appear:

**Note: **It’s important to click **Ctrl+Shift+Enter** instead of just **Enter **after you type in the formula **=MINVERSE(B2:C3)**, otherwise a single value of *-0.33333* will appear in cell E2 without the other three values.

**Finding the Inverse of a 3×3 Matrix**

Suppose we have a **3×3 **matrix C, which has 3 rows and 3 columns:

Here is how to find the inverse of this matrix in Excel:

**Step 1: Enter the data values for the matrix. **

**Step 2: Find the inverse of the matrix.**

- First, highlight a 3×3 group of cells where the output will go. For example, highlight cells
**F2:H4**. - With the cells highlighted, type in
**=MINVERSE(B2:D4)**, then click**Ctrl+Shift+Enter**.

The following results will appear:

**Note: **It’s important to click **Ctrl+Shift+Enter** instead of just **Enter **after you type in the formula **=MINVERSE(B2:D4)**, otherwise a single value of *-0.13793* will appear in cell F2 without any other values.