Difference between revisions of "Documentation/How Tos/Calc: MUNIT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
Line 29: Line 29:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
[[Category: Documentation/Reference/Calc]]
+
[[Category: Documentation/Reference/Calc/Array functions]]

Revision as of 10:59, 12 April 2010


MUNIT

Returns a unit (identity) matrix of a given size.

Syntax:

MUNIT(size)

Calc munit.png
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.

Template:Documentation/SeeAlso

Personal tools