It returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC(array,k)
array: Required. The array or range of data that defines relative standing.
k: Required. The percentile value in the range 0..1, exclusive
An empty array or a k<0 or a k>4 return the #NUM! error
If k is nonnumeric, it returns the #VALUE! error value
If k is not a multiple of 1/(n – 1), it interpolates to determine the value at the k-th percentile
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the PERCENTILE.EXC function:
In the cell B9 calculate the 40th percentile of the cell range B3:M6 inclusive.
In the cell B10 calculate the 40th percentile of the cell range B3:M6 exclusive.
In the cell B11 calculate the 40th percentile of the cell range B3:M6 using the simple PERCENTILE function