next up previous contents index
Next: INVFFT Up: A. Function Reference Previous: INVDFT   Contents   Index


INVERT

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

Excel function: N/A


next up previous contents index
Next: INVFFT Up: A. Function Reference Previous: INVDFT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003