# Manuals/calci/SMALL

Jump to navigation
Jump to search

**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

## Related Videos

## See Also

## References