PrecisionCalc
xl
Precision

xlpSMALL

Returns the k-th smallest number in a cell range, with up to 32,767 significant digits of precision. Same as Excel's built-in SMALL function, but with high precision.

Syntax

xlpSMALL(numlist,k)

 numlist Required. The array or range of cells with the numbers to sort. k Required. The position (from the smallest) in the cell range to return.

Remarks

• numlist can accept cells with both numbers and text.

• numlist can accept cells with text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.

• The return value will be formatted however the chosen input is formatted. To specify number formatting to apply to the return value, xlpSMALL can be formatted by wrapping it in other xlPrecision functions such as xlpADD. See example below.

Examples

Formula Description Result
=xlpSMALL(A1:C5,3)

 A B C 1 10 20 70 2 120 30 110 3 90 60 ABC 4 40 150 5 80 140 100
The 3rd-smallest number in A1:C5. 30

 A B C 1 10000 20000 70000 2 120000 30000 110000 3 90000 60000 ABC 4 40000 150000 5 80000 140000 100000
The 3rd-smallest number in A1:C5, formatted with thousands separators by wrapping xlpSMALL in xlpADD (adding the result of xlpSMALL to 0 to get the same result) and specifying thousands separators in xlpADD. 30,000
=xlpSMALL(A1:A17,5)

 A 1 100000000000000000000.1 2 1000000000000000000000.1 3 10000000000000000000000.1 4 100000000000000000000.01 5 1000000000000000000000.01 6 100000000000000000000.001 7 1000000000000000000000.001 8 100000000000000000000.0001 9 1000000000000000000000.0001 10 \$1,000 11 1,234,567,890,123,456,789.012345 12 \$1,234,567,890,123,456,789.012345 13 1234567890123456789.012345 14 \$100000000000000000000 15 \$1000 16 5 17 1.00000000000000000000000000001
The 5th-smallest number in A1:A17. 1,234,567,890,123,456,789.012345