Documentation/Calc Functions/MUNIT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MUNIT

Category:

Array

Summary:

Returns the unitary square array of a certain size. The unitary array is a square array where the main diagonal elements equal 1 and all other array elements are equal to 0.

Syntax:

MUNIT(Dimensions)

Returns:

Arguments:

Dimensions refers to the size of the array unit.

Additional details:

You can find a general introduction to Array functions at the top of this page.

Examples:

Select a square range within the spreadsheet, for example, from A1 to E5.

Without deselecting the range, select the MUNIT function. Mark the Array check box. Enter the desired dimensions for the array unit, in this case 5, and click OK.

You can also enter the =MUNIT(5) formula in the last cell of the selected range (E5), and press Shift + Ctrl + Enter.

You now see a unit array with a range of A1:E5.

More explanations on top of this page.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: