The Excel PERCENTRANK.INC function returns the relative standing of a value within a data set as a percentage from 0 to 1 inclusive — the inverse of PERCENTILE.INC and the modern replacement for the legacy PERCENTRANK.
Syntax
| Argument | Description | |
|---|---|---|
array | Required | The range or array of numeric data. |
x | Required | The value whose percentile rank you want to find. |
significance | Optional | Number of significant digits in the result. Defaults to 3 if omitted. |
How to use it
PERCENTRANK.INC answers “what fraction of the data is at or below this value?” The INC variant returns a rank from 0 to 1 inclusive, so the smallest value scores 0 and the largest scores 1.
For five points, the value 3 has two values below it out of n-1=4 gaps, giving 2/4 = 0.5. When x falls between two data points, PERCENTRANK.INC interpolates. By default the result is rounded to 3 significant digits; raise significance for more precision.
Inverse pairing: PERCENTRANK.INC and PERCENTILE.INC undo each other. If PERCENTILE.INC(data,0.5) is 3, then PERCENTRANK.INC(data,3) is 0.5.
Try it: interactive demo
Pick a PERCENTRANK.INC example to see the formula and its result.
Practice workbook
Frequently asked questions
What does PERCENTRANK.INC return for the smallest and largest values?
What is the significance argument for?
How is PERCENTRANK.INC different from PERCENTRANK.EXC?
n-1 and ranges 0 to 1 inclusive; EXC divides by n+1 and keeps results strictly between 0 and 1. For the same x they usually return different ranks.Is PERCENTRANK.INC the same as the old PERCENTRANK?
PERCENTRANK is retained as a Compatibility function; PERCENTRANK.INC is the current name.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class