PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpLARGE
Returns the k-th largest number in a cell range, with up to 32,767 significant digits of precision. Same as Excel's built-in LARGE function, but with high precision.
Syntax
xlpLARGE(numlist,k)
| numlist | Required. The array or range of cells with the numbers to sort. |
| k | Required. The position (from the largest) 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, xlpLARGE can be formatted by wrapping it in other xlPrecision functions such as xlpADD. See example below.
Examples
| Formula | Description | Result | ||||||||||||||||||||||||||||||||||||
=xlpLARGE(A1:C5,3)
|
The 3rd-largest number in A1:C5. | 120 | ||||||||||||||||||||||||||||||||||||
=xlpADD(xlpLARGE(A1:C5,3),0,,TRUE)
|
The 3rd-largest number in A1:C5, formatted with thousands separators by wrapping xlpLARGE in xlpADD (adding the result of xlpLARGE to 0 to get the same result) and specifying thousands separators in xlpADD. | 120,000 | ||||||||||||||||||||||||||||||||||||
=xlpLARGE(A1:A17,13)
|
The 13th-largest number in A1:A17. | 1,234,567,890,123,456,789.012345 |
See Also