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

ArgumentRequired?What it does
arrayYesA square range of numbers.

Examples

Example 1 — Inverting a 2×2

The inverse of [[4, 7], [2, 6]].

C1fx=MINVERSE(A1:B2)
ABCD
1470.6-0.7
226-0.20.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

Kyle Stott

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.