Documentation/Calc Functions/SMALL

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

SMALL

Category:

Statistical Analysis

Summary:

Returns the Rank_c-th smallest value in a data set.

Syntax:

SMALL(Data; RankC)

Returns:

Arguments:

Data is the cell range of data.

RankC is the rank of the value. If RankC is an array, the function becomes an array function.

Additional details:

Examples:

=SMALL(A1:C50;2) gives the second smallest value in A1:C50.

=SMALL(A1:C50;B1:B5) entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5.

Related LibreOffice functions:

ODF standard:

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

Equivalent Excel functions: