PERCENTRANK.INC Function
Returns a value's rank as a percentage of the data set (0 to 1 inclusive).
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number from 0 to 1
Want to practice PERCENTRANK.INC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
PERCENTRANK.INC is the reverse of PERCENTILE.INC: give it a value and it tells you what share of the data is below it. The smallest value is 0 and the largest is 1.
Results are cut (not rounded) to 3 decimal places unless you set significance.
Syntax
=PERCENTRANK.INC(array, x, [significance])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | The range of numbers. |
| x | Yes | The value to rank. If it's between two data points, the result is interpolated. |
| significance | No | Decimal places to keep (default 3). Extra digits are cut off, not rounded. |
Examples
Example 1 — Each rep's percentile rank
Format column D as a percentage: Ana beat 83.3% of the others.
D2fx=PERCENTRANK.INC($C$2:$C$8,C2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Region | Sales | Pct rank |
| 2 | Ana | North | 62000 | 0.833 |
| 3 | Ben | South | 48500 | 0.166 |
| 4 | Cy | North | 50000 | 0.5 |
| 5 | Di | East | 71250 | 1 |
| 6 | Ed | South | 39800 | 0 |
| 7 | Fay | North | 55400 | 0.666 |
| 8 | Gus | East | 48500 | 0.166 |
=PERCENTRANK.INC($C$2:$C$8,C2) Explain
Common mistakes
- #N/A x is smaller than the minimum or larger than the maximum.
- #NUM! significance is less than 1.
- 0.166, not 0.167. Results are cut off, not rounded. 1/6 shows as 0.166.
Notes
- Same as the older PERCENTRANK function.
- Related functions: PERCENTRANK.EXC, PERCENTILE.INC, RANK.EQ.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.