Products, services, and OS functions
may not be available in this country.

MDETERM

The MDETERM function returns the determinant of a matrix. The determinant is a single numerical value calculated from a square matrix.

MDETERM(matrix)

matrix: A numeric array with an equal number of rows and columns.

Notes

  • MDETERM will return an error if the number of rows is not equivalent to the number of columns.

Examples

Given the following matrix:

A

B

C

1

5

3

7

2

6

9

2

3

1

8

3

=MDETERM(A1:C3) returns 280.

=MDETERM(A1:B2) returns 27.

=MDETERM(A1:C2) returns an error because there is not an equal number of rows and columns.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.