Manuals/calci/MDETERM

From ZCubes Wiki
Revision as of 21:39, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Syntax


Remarks


Examples


'''''''  ''''

Description


MDETERM


 

MDETERM(a)

Where a is a numeric array, have same number of rows and columns.




 
  • a can be given as a cell range, {1,2,3;4,5,6;7,8,9}; or as a name to either of these.
  • Matrix determinants are generally used for solving systems of mathematical equations that involve several variables.

 





 

MDETERM function gives you the matrix determinant of an array.





                C1       C2         C3      C4

R1            2          3            4         5

R2            2          5            1         4

R3           5          5             4         6

R4           4          1             5         2

That is MDETERM (B2:E5) is 84

 


Column1 Column2 Column3 Column4
Row1 2 3 4 5
Row2 2 5 1 4
Row3 5 5 4 6
Row4 4 1 5
2
Row5 84
Row6