# PERCENTILE.INC

## Content

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

## Syntax

`PERCENTILE.INC(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 non-numeric, #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).

## Examples

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