# Manuals/calci/SMALL

SMALL(Array,k)

• is the set of numbers.
• is the position of a smallest number.
• SMALL(),returns the k-th smallest value in a data set.

## Description

• This function gives the smallest value in given array of numbers.
• In , is the array or range of cells containing the data to be used in the function and is the position of the smallest number.
• This function can be used to find data based on relative size.
• Here = Smallest value in the given set.
• Suppose there is number of data points in a given array, then = Largest value in the given set.
• This function will give the result as error when
 1. The  values are empty.
2.  or  is greater than the number of data points.


## Examples

• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],2) = -1
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],7) = 9
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],1) = -5
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],14) = 70
A B C D E F G
1 -6 -12 -20 -10 -15 0 -25
2 1.2 1.5 1.25 1.62 1.521 1.7 1.76
• =SMALL(A1:G1,4) = -12
• =SMALL(A1:G1,6) = -6
• =SMALL(A2:G2,6) = 1.7
• =SMALL(A2:G2,8) = NAN

SMALL