[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
SMALL ( array , k )
Description: Computes the kth smallest value in a data set.
Arguments:
|
Name |
Type |
Description |
|
array |
array, reference |
The set of numbers from which the kth-smallest value is to be determined. |
|
number |
The position (from the smallest) in the array or cell range of data to return. |
Return Type and Value: number – The kth smallest value in a data set.
However, if
• array is empty, the return value is unspecified.
• k ≤ 0 or k is greater than the number of data points, #NUM! is returned.
[Example:
SMALL({3,5,3,5,4;4,2,4,6,7},3) results in 3
SMALL({3,5,3,5,4;4,2,4,6,7},7) results in 5
end example]