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