 Formula Engine Reference Guide |
|
Back to Class Index
PERCENTRANK(R, N)
This function returns the percentile rank of the number N among the values in range R.
Parameters
R
A range of data
N
A number whose percentile rank to find
Examples
PERCENTRANK(A1..A6, 4.5) = 0.7
where A1..A6 = 1, 2, 3, 4, 5, 6
PERCENTRANK(B1..B6, 21.35) = 0.77
where B1..B8 = 3.8, 23, 4, 12, 67, 0.2