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.
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.
How to use the PERCENTILE Function in Excel
How to use the PERCENTILE.INC Function in Excel
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.