## Excel PERCENTILE Function:

In this article, we are going to see how to use the **Excel PERCENTILE Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

##
**PERCENTILE Function – Description:**

- This function
**returns the K**.^{th}percentile of the given set of data - The percentile is a value below which a given percentage of values will be taken.
- You can use the percentile to find the
**90**percentile,^{th}**80**percentile, and so on.^{th}

## Syntax:

**=PERCENTILE(array, k)**

### Arguments Explanation:

**Array – ** It is the input array or range of data.

**K – ** This is the number that represents the **k ^{th}** percentile. It should be in the range from

**0 to 1**.

### Note:

- If
**k is less than 0 or greater than 1**and then this function returns**#NUM! Error**. -
**K**must be given as a**decimal value that lies between 0 and 1**or a**percentage**(30%). - If
**K**is non-numeric values such as**letters**and**symbols**and then this function returns**#VALUE! Error**. - If
**k**is not a multiple of**1/(n-1)**, PERCENTILE will insert to determine the value at the**k**percentile.^{th}

## Examples:

Let’s see some examples to understand how the **PERCENTILE** function will work.

### Example 1:

- In the below screenshot, you can be able to see the input range in
**Column****B**, and it’s**K**values are given in^{th}**Column****D**. - The output is displayed in
**Column****E**.

### Example 2:

- If
**k is less than 0 or greater than 1**and then this function returns**#NUM! Error**.

### Example 3:

- If
**K**is non-numeric values such as**letters**and**symbols**and then this function returns**#VALUE! Error**.

From the above examples, you can clearly understand how to use **PERCENTILE** Function.

## Conclusion:

In this article, you can understand the usage of **Excel PERCENTILE Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **Geek Excel.** Keep Learning!!

### Similar Functions:

**PERCENTILE.EXC Function****PERCENTILE.INC Function**

## Discussion