Syntax
PERCENTRANK.INC(array, x, [significance])
| Parameter | Description |
|---|---|
| array | Parameter of the PERCENTRANK.INC function. |
| x | Parameter of the PERCENTRANK.INC function. |
| [significance] | (Optional.) Parameter of the PERCENTRANK.INC function. |
Examples
Employee performance percentile
Formula
=PERCENTRANK.INC(B2:B100, B15)
Returns the percentile rank of the employee in row 15 among all 99 employees. A result of 0.92 means they outperform 92% of the team.
Benchmark a value
Formula
=PERCENTRANK.INC(D2:D500, 75000)
Finds where a salary of $75,000 falls in the company's salary distribution. Returns a value between 0 and 1.
Ranking with precision
Formula
=PERCENTRANK.INC(A1:A50, 30, 5)
Returns the rank with 5 significant digits for more precise ranking.
Common Errors
#N/A
The value x is outside the range of the data set (less than the minimum or greater than the maximum).
#NUM!
The array is empty or contains no numeric values.
Tips
Same as PERCENTRANK
PERCENTRANK.INC is identical to PERCENTRANK. Use the .INC version for clarity and forward compatibility.
Range is 0 to 1 inclusive
The smallest value in the array gets rank 0, and the largest gets rank 1. This is the inclusive behavior that distinguishes it from .EXC.
Useful for grading curves
Convert raw test scores to percentile ranks to create a curve. Students can see where they stand relative to the class regardless of absolute score.
Try PERCENTRANK.INC in Viztab
Import your data and use PERCENTRANK.INC with 370+ other formulas. No signup required.
Open Viztab