# PERCENTILE

## Content

This function returns the *n*th percentile of values in a range.

## Syntax

`PERCENTILE(array, n)`

## Arguments

This function has these arguments:

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

## Examples

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