Excel functions / Math
MINVERSE function
The inverse of a square matrix.
Syntax
=MINVERSE(array)
Arguments
array: A square matrix of numbers.
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
Solve 2x + y = 5 and x + 3y = 10
A B C D E F 1 2 1 5 1 2 1 3 10 3 In F1:
=MMULT(MINVERSE(A1:B2), D1:D2)→ 1; 3x is 1 and y is 3.
Common mistakes
- No inverse. A matrix whose determinant is 0 has no inverse: the result is #NUM!.
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.
- Czech: INVERZE
- Danish: MINVERT
- Dutch: INVERSEMAT
- Finnish: MKÄÄNTEINEN
- French: INVERSEMAT
- German: MINV
- Hungarian: INVERZ.MÁTRIX
- Italian: MATR.INVERSA
- Norwegian: MINVERS
- Polish: MACIERZ.ODW
- Portuguese (Brazil): MATRIZ.INVERSO
- Portuguese (Portugal): MATRIZ.INVERSA
- Russian: МОБР
- Spanish: MINVERSA
- Swedish: MINVERT
- Turkish: DİZEY_TERS
Try MINVERSE in the playground