SMALL function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
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.
See Also
