Syntax: @PERCENTILE(R, N)
R = A range of data
N = A numeric value between 0 and 1, inclusive
@PERCENTILE returns the datum from the range R which is at the Nth percentile in R. Only numeric data in R are considered.
The result will be interpolated if N is not a multiple of 1/(s-1), where s is the size of R.
Examples:
@PERCENTILE(A1..A4, 0.65) = 2.95, where A1..A4 = 1, 2, 3, 4
@PERCENTILE(B1..B6, 0.75) = 21.35, where A1..A6 = 3.8, 23, 4, 12, 67, 0.2