The
MDETERM() function calculates
the determinant of an array.
- The syntax for the function
is MDETERM (array).
The
argument "array" can
be an array of numerical values, a reference
to a range of cells or a named range. However
the array must be "square" that
is, it must have the same number of rows
and columns.
Note:
The function will return a #VALUE error
if an element of the array equals zero
or has no assigned value.
The
MDETERM function returns the determinant
of a array (matrix). For Example MDETERM({1,2,3;4,5,6;7,8,9})
= -24. The determinant of a matrix is a
scalar (dimensionless) number that uniquely
characterizes a matrix. The value of which
can be used to find solutions to equations
with multiple variables (when the equations
are represented in an array).
The
MDTERM finds the determinant by using manipulating
the elements of the array in a very specific
way eg. to find the determinant of the
square array {A1,A2,A3;B1,B2,B3;C1,C2,C3}=
A1*(B2*C3-B3*C2)-A2*(B1*C3-B3*C1)+A3*(B1*C2-B2*C1)
or more specifically {1,2,3;4,5,6;7,8,9}=
1*(5*9-6*8)-2*(4*9-6*7)+3*(4*8-5*7) = (45-48)-2*(36-42)+3*(32-35)=(-3)-(-12)+(-9)=
0.
To
learn more about the determinant see [The
Determinant Mathematics knowledgebase]
[The
MMULT() function knowledgebase]
[The MINVERSE()
function knowledgebase]
[The TRANSPOSE() function knowledgebase]
|
