Difference between revisions of "Documentation/How Tos/Calc: SMALL function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 15: | Line 15: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
− | * [[Documentation/How_Tos/Calc: LARGE function|LARGE]] | + | * [[Documentation/How_Tos/Calc: LARGE function|LARGE]] |
− | * [[Documentation/How_Tos/Calc: RANK function|RANK]] | + | * [[Documentation/How_Tos/Calc: RANK function|RANK]] |
− | * [[Documentation/How_Tos/Calc: MAX function|MAX]] | + | * [[Documentation/How_Tos/Calc: MAX function|MAX]] |
* [[Documentation/How_Tos/Calc: MIN function|MIN]] | * [[Documentation/How_Tos/Calc: MIN function|MIN]] | ||
Revision as of 14:39, 26 February 2009
SMALL
Returns the nth smallest value in a list of numbers.
Syntax:
SMALL(numberlist; n)
- returns the nth smallest number within the (unordered) range or array of numbers numberlist.
Example:
SMALL(B1:B4; 3)
- where cells B1, B2, B3, B4 contain 4, 7, 5,and 8, returns 7. The lowest number is 4, then 5, then the third lowest is 7.