# 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* | Array of values representing the data |
| *n* | Value representing the percentile value between 0 and 1 |

## Data Types

Accepts numeric data for both arguments. Returns numeric data.

## Examples

`PERCENTILE(A1:A12,0.95)`

`PERCENTILE(R1C1:R1C45,0.866)`

`PERCENTILE({5,15,25,50,65},0.45)` gives the result 23.