Syntax
PERCENTRANK(array, x, [significance])
| Parameter | Description |
|---|---|
| array | Parameter of the PERCENTRANK function. |
| x | Parameter of the PERCENTRANK function. |
| [significance] | (Optional.) Parameter of the PERCENTRANK function. |
Examples
Student percentile rank
Formula
=PERCENTRANK(C2:C200, C5)
Returns the percentile rank of the student in C5 among all 199 scores. A result of 0.85 means they scored higher than 85% of students.
Product ranking
Formula
=PERCENTRANK(D2:D50, 150)
Returns where the value 150 falls in the distribution. If it returns 0.6, then 150 is at the 60th percentile of the data.
With significance
Formula
=PERCENTRANK(A1:A100, 42, 4)
Returns the percentile rank rounded to 4 decimal places instead of the default 3.
Common Errors
#N/A
Returned when the value x is not within the range of values in the array (below the minimum or above the maximum).
#NUM!
Returned when the array contains fewer than 1 numeric value.
Tips
Default is 3 decimal places
The optional significance argument defaults to 3, giving results like 0.852. Increase it for finer precision if needed.
Interpolates between values
If x falls between two data points, PERCENTRANK interpolates linearly. The value doesn't need to exist in the data set.
Inverse of PERCENTILE
PERCENTRANK and PERCENTILE are inverses. If PERCENTILE(data, 0.75) = 500, then PERCENTRANK(data, 500) = 0.75.
Try PERCENTRANK in Viztab
Import your data and use PERCENTRANK with 370+ other formulas. No signup required.
Open Viztab