How to Easily Find the Inverse of a Matrix in Excel

 

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

Inverse of a matrix in Excel example

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.

Leave a Reply

Your email address will not be published. Required fields are marked *