In this article, we will learn about how to use the PERCENTILE.EXC function in Excel.

The PERCENTILE.EXC is extension function of PERCENTILE function. This function takes the range of values and returns kth percentile of the range.

=PERCENTILE.EXC (array, k)

Value of k : must be a number between  0<k<1 : 0 & 1 are excluded. The PERCENTILE.EXC generates a #VALUE error if k is non-numeric.

For example 0.5 will return the 50th percentile

This function generates #NUM error if k exceeds 0<k<1. Whereas 0 & 1 are included in PERCENTILE.INC function.

Let’s understand this function using it as an example.

Here we have a set of values from A1:A46 and we need to find some percentile values.
Use the formula:


This function calculates the 10th percentile of the range
As you can see, the function returns the 10th percentile.
Now copy the formula to get different percentile values of the range to the remaining cells.
As you can it generates #NUM error when value doesn’t lie between 0 & 1 (excluded).

Hope you understood how to use PERCENTILE.EXC function in Excel. Explore more articles on Excel mathematical function here. Please feel free to state your query or feedback for the above article.

Related Articles:

How to use the PERCENTILE Function in Excel

How to use the PERCENTILE.INC Function in Excel

Percentage Decrease Change

Calculate Percentage Discount

Calculate Percentage of Total in Excel

Increase by percentage

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube