MINVERSE Function
Returns the inverse of a square matrix.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
An array that spills
Want to practice MINVERSE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MINVERSE returns the matrix that, multiplied by the original, gives the identity matrix.
Its classic use is solving simultaneous equations: =MMULT(MINVERSE(coefficients), totals).
Syntax
=MINVERSE(array) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | A square range of numbers. |
Examples
Example 1 — Inverting a 2×2
The inverse of [[4, 7], [2, 6]].
C1fx=MINVERSE(A1:B2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 4 | 7 | 0.6 | -0.7 |
| 2 | 2 | 6 | -0.2 | 0.4 |
=MINVERSE(A1:B2) Explain
Example 2 — Solving two equations
Widgets (x) and gadgets (y): 4x + 7y = 100 and 2x + 6y = 70. Coefficients in A1:B2, totals in E1:E2.
=MMULT(MINVERSE(A1:B2), E1:E2) Explain
Returns x = 11 and y = 8.
Common mistakes
- #NUM! The matrix has no inverse (its determinant is 0).
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.