PERCENTILE.EXC Function
Returns the k-th percentile, with k strictly between 0 and 1.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
PERCENTILE.EXC finds percentiles using the (n + 1) method common in statistics packages. With n values, k must be between 1/(n+1) and n/(n+1).
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, strictly between 0 and 1. |
Examples
Example 1 — Sales percentiles (exclusive)
With 7 values, k must be from 1/8 (0.125) to 7/8 (0.875), so 0.1 is out of range.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | k | Percentile |
| 2 | Ana | North | 62000 | 0.1 | #NUM! |
| 3 | Ben | South | 48500 | 0.25 | 48500 |
| 4 | Cy | North | 50000 | 0.5 | 50000 |
| 5 | Di | East | 71250 | 0.8 | 65700 |
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Common mistakes
- #NUM! k is 0, 1, or too close to either end for the amount of data.
Notes
- Related functions: PERCENTILE.INC, QUARTILE.EXC, PERCENTRANK.EXC.

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.