Quick Navigation
MINVERSE Function
Summary
The MINVERSE function computes the inverse of a square matrix provided as an array. Essential for linear algebra operations, matrix inversion enables solving systems of linear equations and various advanced mathematical computations in Excel.
Syntax
MINVERSE(array)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| array | Array |
Yes | Square numeric array with equal rows and columns (range, constant, or named range) |
Using the MINVERSE Function
MINVERSE returns the inverse matrix, where multiplying the original matrix by its inverse yields the identity matrix (1s on diagonal, 0s elsewhere). Use for solving Ax=b equations by computing x = A⁻¹b, statistical modeling, and engineering calculations.
Common MINVERSE Examples
2x2 Matrix Inversion
=MINVERSE(A1:B2)Select equal-sized output range first, enter formula in top-left cell, confirm with Ctrl+Shift+Enter (legacy) or Enter (Microsoft 365). Inverts matrix in A1:B2.
3x3 Matrix Example
=MINVERSE({1,2,3;0,1,4;5,6,0})Direct array constant inversion. Result is another 3x3 matrix. Use dynamic array behavior in modern Excel.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Array contains text/empty cells or unequal rows/columns
Solution: Verify all numeric data and square dimensions
#NUM! error
Cause: Matrix is singular (determinant = 0)
Solution: Check matrix invertibility; use MDETERM to verify determinant ≠ 0
Notes
- Output requires same dimensions as input (n×n)
- Identity matrix verification: MMULT(array, MINVERSE(array)) should approximate identity
- 16-digit precision may cause minor rounding differences
- For 2×2 matrix [a b; c d], inverse = 1/(ad-bc) * [d -b; -c a]
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+