How to Use the PERCENTILE Function in Excel

This guide explains how to use PERCENTILE Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function performs returning the kth percentile of values in the specified array or data range.

Syntax: PERCENTILE (array, k) .

Inside:

- array: An array or range of data to determine percentile for values, which is a required parameter.

- k: Percentage value to determine rank, is a required parameter. The value of k ranges from 0 to 1 including 1.

Attention:

- The value k must be in paragraph [0,1] otherwise the function returns the #NUM! Error value.

- If the value k is not in the form of numbers, the function returns the error value #VALUE!

- The case when k is not a multiple of 1 / (n-1) PERCENTILE function will interpolate to calculate percentile value.

For example:

Find the value of 0.9 percentile in the data array:

In the cell to calculate the value enter the formula: = PERCENTILE (D13: L13, D14) -> Press Enter the result received is:

So the 0.9th percentile has a value of 28.

Note: When entering the percentile value is always greater than or equal to 0 and less than or equal to 1. If the percentile value is greater than 1 error function:

The percentile value is less than 0 error:

Above is the way to use PERCENTILE function, you pay attention to the use and problem of entering percentile values in the limit of 0 and 1.

Good luck!