How to Use Excel PERCENTILE.EXC Function in Office 365? – (with Examples)
Tags: excelfunctions, excelpercentileexcfu
Published: 2020-09-18 10:37:14

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

## PERCENTILE.EXC Function:

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

In this article, you will learn the usage of **Excel PERCENTILE.EXC 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.EXC – Explanation:**

- This function **returns the K<sup>th</sup> percentile of the set of data where the value of k is 0 to 1.**
- 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.EXC(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 or equal to 0 or greater than or equal to 1** and then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the array is empty, it will return **[#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 **PERCENTILE.EXC** 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-65.png)<figcaption id="caption-attachment-14144">Example 1</figcaption>

### Example 2:

- If **k is less than or equal to 0 or greater than or equal to 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-60.png)<figcaption id="caption-attachment-14145">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-24.png)<figcaption id="caption-attachment-14146">Example 3</figcaption>

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

## Wrap-Up:

In the above article, you can clearly understand the usage of **Excel PERCENTILE.EXC Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

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

### Read Ahead:

- [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/)
- [How to Use Excel SMALL Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)