Excel like a finance pro.
Statistical function
PERCENTRANK.INC
Returns the percentile rank of a value within a list.
When to use it
The reverse of PERCENTILE.INC: where does a value sit within the data, as a fraction from 0 to 1. The optional significance sets the number of digits.
The shape of it
- Syntax
=PERCENTRANK.INC(array, x, [significance])
Worked examples
A value in the set
=PERCENTRANK.INC({1,2,3,4,5},4) → 0.75
Three of the four other values are below 4.
Minimum
=PERCENTRANK.INC({1,2,3,4,5},1) → 0
The minimum.
Interpolated
=PERCENTRANK.INC({1,2,3,4,5},2.5,2) → 0.375
Between 2 (0.25) and 3 (0.5), to two significant digits... shown as 0.37 with significance 2.
Worth knowing
- "You scored better than 82% of applicants" is PERCENTRANK.INC.
- Default significance is 3 digits; pass a larger number for more precision.
- Values outside the data range return #N/A.
Where it goes wrong
- #N/A when x is outside the data.
- Rounds to 3 significant digits by default, which can hide small differences.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.