Related Functions:

The PERCENTILE.EXC function returns the k-th 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.




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


  A B C D
1 Data      
2 1      
3 3      
4 4      
5 7      
6 8      
7 9      
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 non-numeric
#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