Skip to content
Google Sheets

MINVERSE function in Google Sheets

Returns the multiplicative inverse of a square matrix specified as an array or range.

=MINVERSE(square_matrix)

MINVERSE syntax and parameters

One argument, one required.

  • square_matrixarrayRequired

    An array or range with an equal number of rows and columns representing a matrix whose multiplicative inverse will be calculated.

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 Excel

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 Google Sheets gets this done.