Menu
EXCEL MINVERSE FUNCTION
Excel MINVERSE Function Introduction
The MINVERSE function in Excel computes the inverse of a square matrix.
Description of Excel MINVERSE Function
Syntax :
=MINVERSE( array )
Parameters :
The array parameter is a value array representing a square matrix (i.e. a matrix that has the same number of rows as columns). The inverse matrix that results has the same number of rows and columns as the original given array. However, keep in mind that the Minverse function output is calculated to around 16 decimal places, so there may be some minor rounding mistakes.
Step By Step Guide of MINVERSE Function
Example :
In cells A1-D4 of the sample spreadsheet, the Excel Minverse function is used to compute the inverse of the 4×4 matrix. =MINVERSE ( A1:D4 )
Key Points
- #VALUE! – This error occurs if the provided array has a blank or a non-numeric value, or if the supplied array does not have an equal number of rows and columns.
- #NUM! – This value is returned if the supplied matrix is singular, i.e. there is no inverse for the specified matrix.
- #N/A – Occurs in cells that are not within the range of the resultant matrix. For example, if we highlighted cells F1-I5 before entering the Minverse function in the above example, the ‘extra’ cells, F5-I5, are not included in the resultant matrix. As a result, these cells will show the #N/A error.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
