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

ArgumentRequired?What it does
arrayYesThe range of numbers.
xYesThe value to rank. If it's between two data points, the result is interpolated.
significanceNoDecimal 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)
ABCD
1RepRegionSalesPct rank
2AnaNorth620000.833
3BenSouth485000.166
4CyNorth500000.5
5DiEast712501
6EdSouth398000
7FayNorth554000.666
8GusEast485000.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

Kyle Stott

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.