next up previous contents index
Next: DFT Up: A. Function Reference Previous: DEGREES   Contents   Index


DET

Syntax: DET(M)

M = a range, which must contain an equal number of rows and columns.

DET returns the determinant of the matrix specified by the range M, which must be square.

Examples:

Matrix A1..C3 =

  A B C
1 1 2 6
2 3 4 11
3 4 7 2
       

DET(A1..C3) = 37

DET(A1..B3) = Error - DET, matrix must be square

Excel function: N/A


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