Syntax
PERCENTILE(array,k)
The following are the arguments to the PERCENTILE function:
array is a must. The set of data that determines one's relative position.
The letter k is required. In the range of 0..1, the percentile value.
Remarks
PERCENTILE returns the #VALUE! error value if k is not a number.
PERCENTILE returns the #NUM! error value if k is 0 or if k > 1.
PERCENTILE interpolates the value at the k-th percentile if k is not a multiple of 1/(n - 1).
Example
The 30th percentile of the list will be found in cells E2:E5 in this case.
![Excel PERCENTILE function to return the 30th percentile of a given range with =PERCENTILE(E2:E5,0.3).](https://support.content.office.net/en-us/media/c8a533ae-3e36-492c-8134-e9f62312248d.jpg)