MINVERSE
Returns the matrix inverse of an array.
Math & TrigonometryMath Basics
What it does
Calculates the inverse of a square matrix.
Syntax
MINVERSE(array)
Arguments
array(array) — Square matrix.
Examples
Matrix Inverse
Invert a 2x2 matrix.
FORMULA
=MINVERSE(A1:B2)
RESULT
[4, -2; -3, 1]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |