How to Use Excel PERCENTILE Function in Office 365? – (with Examples)
Tags: excelfunctions, excelpercentilefunct
Published: 2020-09-18 10:36:53

---
title: How to Use Excel PERCENTILE Function in Office 365? – (with Examples)
published: true
date: 2020-09-18 04:52:13 UTC
tags: ExcelFunctions,ExcelPERCENTILEFunct
canonical_url: https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/
---

## Excel PERCENTILE Function:

![PERCENTILE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/PERCENTILE-Function.png)<figcaption id="caption-attachment-14141">PERCENTILE Function</figcaption>

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](https://www.microsoft.com/en-in/microsoft-365/excel)

## **PERCENTILE Function – Description:**

- This function **returns the K<sup>th</sup> 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<sup>th</sup>** percentile, **80<sup>th</sup>** percentile, and so on.

## 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<sup>th</sup>** 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**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- **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**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If **k** is not a multiple of **1/(n-1)**, PERCENTILE will insert to determine the value at the **k<sup>th</sup>** percentile.

## 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<sup>th</sup>** values are given in **Column**  **D**.
- The output is displayed in **Column**  **E**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-64.png)<figcaption id="caption-attachment-14137">Example 1</figcaption>

### Example 2:

- If **k is less than 0 or greater than 1** and then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-59.png)<figcaption id="caption-attachment-14138">Example 2</figcaption>

### Example 3:

- If **K** is non-numeric values such as **letters** and **symbols** and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-23.png)<figcaption id="caption-attachment-14139">Example 3</figcaption>

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.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

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

### See Also:

- [How to Use Excel STDEVP Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdevp-function-in-office-365-with-examples/)
- [How to Use Excel COMBIN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-combin-function-in-office-365-with-examples/)