Returns the nth smallest value in a range.
SMALL(array, k)
Statistical Functions.
=SMALL(C2:C9,2)
Returns $1,250
The second-smallest order value.
Asking for a position beyond the number of values returns #NUM!.