Excel functions / Math

MINVERSE function

The inverse of a square matrix.

Syntax

=MINVERSE(array)

Arguments

When to use it

MINVERSE gives the inverse of a square matrix, and spills it. Multiplied by the inverse, a matrix gives the identity. Its practical use is solving equations: MMULT(MINVERSE(A), b) solves A × x = b.

Examples

  1. Solve 2x + y = 5 and x + 3y = 10

    ABCDEF
    12151
    213103

    In F1: =MMULT(MINVERSE(A1:B2), D1:D2) → 1; 3

    x is 1 and y is 3.

    Try this example

Common mistakes

MINVERSE in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try MINVERSE in the playground

Related functions