DET(M)

Top  Previous  Next

 

Description

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

 

Parameters

 

M

A range that must contain an equal number of rows and columns.

 

Examples

 

Given:

 

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

Matrix must be square.

 

Sponsored

Try Predictive Systems Lab

Interactive Demo →

Need Help?
Contact support