Formula Engine Reference Guide
 

 

Back to Class Index

 

DET(M)

Description
This function returns the determinant of the matrix specified by the range M, which must be square.
 
Parameters
M

A range, which must contain an equal number of rows and columns.
 
Examples
Matrix A1..C3 =
A B C
1 2 6
3 4 11
4 7 2
DET(A1..C3) = 37
 
DET(A1..B3) = Error - DET, matrix must be square