Buzz
This article introduces the formula syntax, usage, and illustrative examples of the MINVERSE() function. MINVERSE is among the commonly used calculation functions in Excel, applicable to Office versions 2016, 2013, 2010, 2007, and 2003.
- See also: Matrix functions
The MINVERSE function returns the inverse matrix of a given matrix
Syntax:
MINVERSE(array)
Where:
Array An array with an equal number of rows and columns (mandatory part)
Illustrative Example: Find the inverse matrix of the following matrix { 1,2,1;3,4,-1;0,2,0}
Step 1: Open the Excel software and enter the matrix for {1,2,1;3,4,-1;0,2,0} as shown:
Step 2: In cell B13, enter the formula: = MINVERSE(B7:D9)
Step 3: Press Enter in cell B13 to obtain the value “0.25” as shown
Step 4: In cell B13, select the data range B13: D15, then press F2
Step 5: Press the Ctrl+Shift+Enter key combination to get the result as shown
The result of the inverse matrix is: { 0.25,0.25,-0.75;0,0,0.5;0.75,-0.25,-0.25}
So, this article has guided you on how to utilize the MINVERSE function, which returns the inverse matrix of a given matrix. Additionally, you can explore the article on the MMULT function, which returns the matrix product of two matrices at Mytour.
