Documentation/How Tos/Calc: MUNIT 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
MUNIT
1.1
Syntax:
1.2
Example:
MUNIT
Returns a unit (identity) matrix of a given size.
Syntax:
MUNIT(size)
returns the unit matrix, also known as the identity matrix
I
, of size
size
(an integer greater than zero).
The identity matrix has ones on the leading diagonal, and zeroes elsewhere.
MUNIT
returns an array, and must be entered as an array formula (for example by using
Cntrl-Shift-Enter
rather than just
Enter
).
Example:
=MUNIT(2)
when entered as an array formula in cell B3, returns {1;0|0;1}, so that B3, C3, B4, C4 show 1, 0, 0, 1 respectively.
See Also
MDETERM
MINVERSE
MMULT
How To Use Arrays
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
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information