Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelPERCENTILE Function in Excel

# PERCENTILE Function in Excel

## PERCENTILE Function in Excel

The PERCENTILE function in Excel returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance.

### Syntax

`= PERCENTILE(array,k)`

### Arguments:

• array â€“ The array or range of data defines relative standing.
• kÂ â€“ Â The percentile value in the range 0..1, inclusive.

## Possible Errors and Usage Notes

• If the first argument k is non-numeric, the function returns the #VALUE! error value.
• When k is < 0 or if k > 1, the function returns the #NUM! error value.
• When k is not a multiple of 1/(n â€“ 1), the function interpolates to determine the value at the k-th percentile.
• The argument k can be provided as a decimal (.5) or a percentage (50%)

## How to use the PERCENTILE function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

To find the percentile Â of the given numbers, enter the numbers in columns A, and in column B enter the following formula,

Formula: = PERCENTILE(A1:A5,0.5)

Here, A1 refers to the cell name or the cell address and 0.5 is the 50th percentile of the given numbers.

When entered, the function gives you the percentile of the given numbers which is 70.

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021