Quick Navigation
PERCENTRANK Function
Summary
The PERCENTRANK function calculates the relative position of a specific value within a dataset, expressed as a percentage rank (0-1 scale). It shows how a value compares to the entire data range, useful for percentile analysis and performance ranking.
Syntax
PERCENTRANK(array, x, [significance])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| array | Range/Array |
Yes | Numeric data range to analyze |
| x | Number |
Yes | Target value for ranking |
| significance | Number |
No | Decimal precision (1- optional |
Using the PERCENTRANK Function
PERCENTRANK helps identify where a value stands relative to others in a dataset. Common applications include student grading, employee performance evaluation, sales ranking, and statistical analysis. Returns interpolated results for non-exact matches.
Common PERCENTRANK Examples
Exact Match Ranking
=PERCENTRANK(A1:A10,2)Ranks value 2 within dataset. Returns 0.333 (33.3rd percentile) when 3 values <2 and 6 values >2.
Interpolated Ranking
=PERCENTRANK(A1:A10,5)Value 5 not in dataset. Interpolates between ranks of 4 (0.555) and 8 (0.666) to return 0.583.
Custom Precision
=PERCENTRANK(A1:A10,8,2)Returns 0.67 (2 decimal places) for value 8's rank.
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: Empty array or significance <1
Solution: Ensure array has numeric data and significance ≥1
#VALUE!
Cause: Non-numeric x value or array contains text
Solution: Verify all inputs are numeric
Notes
- Deprecated but available for compatibility
- Interpolates between known values
- Default significance=3 (0.xxx format)
- Consider PERCENTRANK.INC/EXC for new workbooks
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+