Documentation/How Tos/Calc: SMALL function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 08:46, 17 July 2018 by Sancho (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Print/export
Tools