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

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

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)

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

So the resultant inverse matrix will be