Skip to main content



Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile.

Sample Usage



The PERCENTILE.INC function syntax has the following arguments:

  • Array     Required. The array or range of data that defines relative standing.

  • K     Required. The percentile value in the range 0..1, inclusive.


  • If array is empty, PERCENTILE.INC returns the #NUM! error value.

  • If k is nonnumeric, PERCENTILE.INC returns the #VALUE! error value.

  • If k is < 0 or if k > 1, PERCENTILE.INC returns the #NUM! error value.

  • If k is not a multiple of 1/(n - 1), PERCENTILE.INC interpolates to determine the value at the k-th percentile.

In order to use the PERCENTILE.INC formula, start with your edited Excellentable

Then type in the PERCENTILE.INC formula in the area you would like to display the outcome:

By adding the values you would like to calculate the PERCENTILE.INC formula for, Excellentable will generate the outcome:


User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.