Excel PERCENTILE.EXC Function

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.
Syntax:

=PERCENTILE.EXC (array, k)

Value of k : must be a number between 0 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 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.
17
Use the formula:

=PERCENTILE.EXC(A1:A46, C2)

This function calculates the 10th percentile of the range
18
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.
19
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.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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