MINVERSE Function in Excel: Inverse of a Matrix

⏱ 1 min readUpdated 28 September 2026

MathLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Common errors and fixes
  5. Related functions

MINVERSE inverts a square matrix — with MMULT it solves simultaneous equations.

Syntax

=MINVERSE(array)
Argument What it means
array Square range.

Examples

Example 1

=MMULT(MINVERSE(A2:B3), D2:D3)

Solves 2x + 3y = 13, x − y = −1 → x = 2, y = 3.

Common errors and fixes

You see Why, and the fix
#NUM! The matrix has no inverse (determinant is 0).

MMULT · MDETERM

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZACCRINT Function in Excel: Interest Earned Since Last CouponExcel Functions A–ZPERCENTRANK.EXC Function in Excel: Percentile Position, Excluding EndsExcel Functions A–ZSIGN Function in Excel: Positive, Negative or Zero?
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong