Related Functions:

The PERCENTILE.INC function returns the k-th percentile of values in a range, where k is in the range 0 to 1, inclusive.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The PERCENTILE.INC function replaces the PERCENTILE function included in earlier versions of Excel.

Syntax

=PERCENTILE.INC(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 (inclusive), of the required percentile

Examples

  A B C E
1 Data      
2 1      
3 3      
4 4      
5 7      
6 8      
7 9      
8        
9 Formula Result Notes
10 =PERCENTILE.INC(A2:A7,0.25) 3.25 Percent rank of 25% in the range A2:A7

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 < 0 or > 1
  the supplied array is empty