# PERCENTILE.EXC

## Content

This function returns the *k* th percentile of values in a range where k is between 0..1, exclusive.

## Syntax

`PERCENTILE.EXC(array, k)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] Array of values representing the data |
| *k* | [Required] Value representing the percentile value between 0 and 1 |

## Remarks

This function returns the #NUM! error value if the array is empty. If *k* is nonnumeric, #VALUE! is returned. If  *k*  = 0 or 1, #NUM! is returned. The function interpolates to determine the value at the *k* th percentile if *k* is not a multiple of 1/(n-1). The function interpolates when the value for the specified percentile is between two values in the array. If the function cannot interpolate for the percentile, #NUM! is returned.

## Examples

`PERCENTILE.EXC(A1:A12,0.95)`
`PERCENTILE.EXC(R1C1:R1C45,0.866)`
`PERCENTILE.EXC({5,15,25,50,65},0.45)` gives the result 22