SMALL function

The SMALL function is one of the statistical functions. It is used to analyze the range of data and find the k-th smallest value.

Syntax

SMALL(array , k)

The SMALL function has the following arguments:

ArgumentDescription
arrayThe selected range of cells you want to analyze.
kThe position of the number from the smallest value, a numeric value greater than 0.
Notes

How to apply the SMALL function.

Examples

The figure below displays the result returned by the SMALL function.

SMALL Function

Host ONLYOFFICE Docs on your own server or use it in the cloud

Article with the tag:
Browse all tags