PERCENTILE.INC Function
Returns the value below which a given percentage of the data falls (0 to 1 inclusive).
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
PERCENTILE.INC(range, 0.9) returns the 90th percentile — the value that 90% of the data is at or below. k can be anything from 0 (the minimum) to 1 (the maximum).
The .INC version includes the end points (0 and 1, the smallest and largest values); the .EXC version excludes them and needs k strictly between them, so it can't reach the minimum or maximum. Both interpolate between values when k falls between two data points.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | The range of numbers. |
| k | Yes | The percentile, from 0 to 1 (0.9 or 90%). |
Examples
Example 1 — Sales percentiles
Sorted, the sales are 39,800 · 48,500 · 48,500 · 50,000 · 55,400 · 62,000 · 71,250. The 90th percentile falls 40% of the way from 62,000 to 71,250.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | k | Percentile |
| 2 | Ana | North | 62000 | 0 | 39800 |
| 3 | Ben | South | 48500 | 0.25 | 48500 |
| 4 | Cy | North | 50000 | 0.5 | 50000 |
| 5 | Di | East | 71250 | 0.9 | 65700 |
| 6 | Ed | South | 39800 | 1 | 71250 |
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Example 2 — Top-10% threshold
Flag reps at or above the 90th percentile.
Common mistakes
- #NUM! k is below 0 or above 1, or the range is empty.
- Typing 90 instead of 0.9. k is a fraction. Use 0.9 or 90%.
Notes
- Same as the older PERCENTILE function.
- Related functions: PERCENTILE.EXC, QUARTILE.INC, PERCENTRANK.INC, MEDIAN.

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.