Return a value's percentile rank within a dataset.
Syntax
PERCENTRANK.INC(array, x, [significance])Arguments
arrayrequired
The range of numeric values.
xrequired
The value to rank.
significanceoptional
Optional number of significant digits.
PERCENTRANK.INC converts a value into its relative standing between 0 and 1. It is useful when you need to show where a score, response time, or metric sits inside a distribution.
=PERCENTRANK.INC(A2:A100, B2)→0.78B2 is higher than about 78% of the dataset.
Select the distribution
Use the full range that defines the comparison set.
Rank the target
Point x at the value whose relative position you need.
It means the value sits at the 78th percentile, higher than roughly 78% of the values in the range.