Syntax: @INVERT(M)
M = a square matrix
@INVERT generates the inverse of the matrix M, which must be square. The result matrix is the same size as the argument matrix. Multiplying M times the result matrix produces an identity matrix (a matrix with 1's in the diagonal and 0's elsewhere). A singular matrix can not be inverted and therefore produces an error when passed to @INVERT.
Examples:
Matrix B9..C10 =
B | C | |
9 | 0 | 1 |
10 | 1 | 2 |
@INVERT(B9..C10) =
-2 | 1 |
1 | 2 |
Matrix A1..B4 =
A | B | |
1 | 0.99 | 0 |
2 | 3 | 6.2 |
3 | 4.1 | 1.1 |
4 | 3.3 | 6.3 |
@INVERT(A1..B4) = Error - @INVERT, matrix must be square
Matrix H8..J10 =
H | I | J | |
1 | 1 | 1 | 1 |
2 | 3 | 1 | 1 |
3 | 7 | 2 | 6 |
@INVERT(H8..J10) =
-0.5 | 0.5 | 0 |
1.375 | 0.125 | -0.25 |
0.125 | -0.625 | 0.25 |