Excel like a finance pro.
← The libraryPractice · 3 questions →
Compatibility function
PERCENTILE
Returns the k-th percentile of a range; still common but PERCENTILE.INC is the current name.
CommonDifficulty 1200 · ProficientUsage rank #166 of 520
When to use it
The k-th percentile with the inclusive method. Still common; PERCENTILE.INC is the current name.
The shape of it
- Syntax
=PERCENTILE(array, k)
Worked examples
Interpolated
=PERCENTILE({1,2,3,4},0.3) → 1.9
Interpolated.
90th
=PERCENTILE({1,2,3,4,5},0.9) → 4.6
The 90th percentile.
Median
=PERCENTILE(A2:A100,0.5) → 52,000
The median.
Worth knowing
- PERCENTILE.INC is identical.
- k between 0 and 1.
- SLA percentiles.
Where it goes wrong
- #NUM! for k outside 0 to 1.
- Autocomplete steers to PERCENTILE.INC.
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.