How to Use Excel PERCENTILE.INC Function in Office 365? – (with Examples)
Tags: excelfunctions, excelpercentileincfu
Published: 2020-09-18 13:44:13

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

## PERCENTILE.INC Function:

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

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

- This function **returns the K<sup>th</sup> percentile of the set of data where the value of k is 0 to 1, inclusive.**
- The value of the percentile lies below the value of the given input percentage.
- You can use the percentile to find the **90<sup>th</sup>** percentile, **80<sup>th</sup>** percentile, and so on.

## Syntax:

**=PERCENTILE.INC(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/).
- 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** (50%).
- 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 make you understand this function clearly.

### 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/11-2.png)<figcaption id="caption-attachment-14187">Example 1</figcaption>

### Example 2:

- If **k is less than 0 or greater than 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-63.png)<figcaption id="caption-attachment-14185">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-26.png)<figcaption id="caption-attachment-14186">Example 3</figcaption>

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

## Verdict:

In the above article, you can understand the usage of **Excel PERCENTILE.INC 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 Function**](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)
- [**PERCENTILE.EXC Function**](https://geekexcel.com/how-to-use-excel-percentile-exc-function-in-office-365-with-examples/)

### Read Ahead:

- [How to Use Excel MINIFS Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/)
- [How to Use Excel STDEVPA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdevpa-function-in-office-365-with-examples/)