SMALL Formula in Excel

What Does It Do ?

This function examines a list of values and picks the value at a user specified position
in the list.

Syntax

=SMALL(ListOfNumbersToExamine,PositionToPickFrom)

Formatting

No special formatting is needed.

Example

The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar.

Note
Another way to find the Highest and Lowest values would have been to use
the =MAX() and =MIN() functions.