PERCENTILE.EXC FunctionWayne Becker20151015T17:05:15+00:00
The PERCENTILE.EXC function returns the kth percentile of values in a range, where k is in the range 0 to 1, exclusive.
 This function was introduced in Excel 2010 and so is not available in earlier versions.
Syntax
=PERCENTILE.EXC(array,k)
Arguments
Argument 
Description 
array 
The range of data values for which you want to calculate the k’th percentile 
k 
The value, between 0 and 1, exclusive, of the required percentile 
Examples

A 
B 
C 
D 
1 
Data 



2 
1 



3 
3 



4 
4 



5 
7 



6 
8 



7 
9 



8 




9 
Formula 
Result 
Notes 
10 
=PERCENTILE.EXC(A2:A7,0.25) 
2.5 
Interpolates when the value for the specified percentile lies between two values in the array 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if the supplied value of k is nonnumeric 
#NUM! 
Occurs if either:

• 
the supplied value of k is is < 1/(n+1) or > n/(n+1) – where n is the number of values in the supplied array 

• 
the supplied array is empty 
