What is PERCENTILE?
Returns the k-th percentile of values in a range. Find where a value stands relative to the dataset.
Syntax
=PERCENTILE(array, k)
Example
Formula: =PERCENTILE(A1:A100, 0.9)
Result: 90th percentile value
How It Works
Returns the value at which k percent of the data falls below. k=0.9 returns the 90th percentile (top 10% threshold).