Formula Engine Reference Guide
 

 

Back to Class Index

 

INVERT(M)

Description
This function 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.
 
Parameters
M

A square matrix
 
Examples
Matrix B9..C10 =
     B   C
 9   0   1
10  1   2
INVERT(B9..C10) =
-2  1
 1  2
 
Matrix A1..B4 =
0   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
375      0.125   -0.25
0.125   -0.625   0.25