The PERCENTRANK function calculates the percentage rank of a number in a set of numbers.
The percent rank of a value is a measure of its standing in relation to a set of values. It is always a number from 0 to 1 inclusive. x is the value for which the percentage rank is sought in comparison to the set of numbers in an array or range.
For example,
PERCENTRANK(2, {0, 1, 2, 3, 4})
returns 0.5
PERCENTRANK(2, {1, 2, 3, 4})
returns 0.333333.
See also: