MINVERSE Function in Excel – Create inverse of a matrix in Excel

MINVERSE Function in Excel calculates the inverse of a square matrix.

Syntax of MINVERSE Function in Excel

MINVERSE( array )            

Array – array of numeric values, that represent a square matrix (i.e. has the same number of rows and columns).

 

Example of MINVERSE Function in Excel

Let’s see how to create inverse of a matrix using MINVERSE Function step by step (we will be creating 3×3 matrix as an example).

Step 1: Select 3X3 Cells as shown below

MINVERSE Function in Excel 1

Step 2: In the formula section specify MINVERSE Function and supply the matrix as an input in the form of array  i.e. =MINVERSE(A1:C3)

MINVERSE Function in Excel 2

Step 3: press Ctrl+Shift+Enter to get the inverse of a matrix

MINVERSE Function in Excel 3

So the resultant inverse matrix will be

MINVERSE Function in Excel 4

previous MINVERSE Function in Excel                                                                                                                next MINVERSE Function in Excel