Documentation/How Tos/Calc: SMALL function

From Apache OpenOffice Wiki
Jump to: navigation, search



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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SMALL_function&oldid=243517"
Views
Personal tools
Navigation
Tools