Documentation/How Tos/Calc: MDETERM function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 08:02, 17 July 2018 by
Sancho
(
Talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Jump to:
navigation
,
search
CALC FUNCTIONS
Arrays Functions
FUNCTIONS
Frequency
Growth
Linest
Longest
Mdeterm
Minverse
Mmult
Munit
Sumproduct
vSumx2my2
Sumx2py2
Sumxmy2
Transpose
Trend
< Previous Page
Next Page >
Contents
1
MDETERM
1.1
Syntax:
1.2
Example:
MDETERM
Returns the determinant of a matrix.
Syntax:
MDETERM(array)
returns the determinant of the square matrix
array
, which may be either an inline array or a range, containing all numbers.
MDETERM
returns a single value. It need
not
be entered as an array formula.
Example:
MDETERM({4;1|2;5})
returns
18
, that is 4*5 - 1*2.
MDETERM(A1:B2)
where A1, B1, A2, B2 contain 4, 2, 2, 3 respectively, returns
8
, that is 4*3 - 2*2.
See Also
MINVERSE
MMULT
MUNIT
How To Use Arrays in Calc
Array functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Array functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information