# Documentation/How Tos/Calc: SMALL function

From Apache OpenOffice Wiki

## SMALL

Returns the n^{th} smallest value in a list of numbers.

### Syntax:

**SMALL(numberlist; n)**

- returns the
**n**^{th}smallest number within the (unordered) range or array of numbers.**numberlist**

### Example:

**SMALL(B1:B4; 3)**

- where cells
,**B1**,**B2**,**B3**contain**B4**,**4**,**7**,and**5**, returns**8**. The lowest number is**7**, then**4**, then the third lowest is**5**.**7**