Skip to content
Excel

MINVERSE function in Excel

Returns the matrix inverse of an array

=MINVERSE(array)

MINVERSE syntax and parameters

One argument, one required.

  • arrayarrayRequired

    A numeric array with an equal number of rows and columns.

MINVERSE examples

Formulas you'll actually reuse.

  1. The inverse of a 3×3 coefficient matrix:

    =MINVERSE(B2:D4)

  2. Solve a system of three linear equations — inverse of coefficients times the constants:

    =MMULT(MINVERSE(B2:D4), F2:F4)

MINVERSE in Google Sheets

Same name — your formula ports as-is.

Try MINVERSE in the playground

Edit the example — nothing to install.

Preloaded with the MINVERSE formula from Example 1 — change anything and watch it respond.

Loading the editor…

MINVERSE errors

What they mean — and the fixes.

  • #NUM!

    The matrix is singular (its determinant is 0) — it has no inverse; check for a duplicated or all-zero row.

Related functions

More ways Excel gets this done.