The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Syntax
=PERCENTILE.EXC(array,k)
The PERCENTILE.EXC function syntax has the following arguments:
| Argument | Description |
|---|---|
| array | Required. The array or range of data that defines relative standing. |
| k | Required. A percentile value in the range 0 < k < 1. |
Note
- If array is empty, PERCENTILE.EXC returns the #NUM! error value.
- If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.
- If k is ≤ 0 or if k ≥ 1, PERCENTILE.EXC returns the #NUM! error value.
- If k is not a multiple of 1/(n + 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.
- PERCENTILE.EXC will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.
Example
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.