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.

PERCENTILE.INC takes 2 required arguments and no optional arguments:

Syntax: PERCENTILE.INC(array, k)

The arguments for the PERCENTILE.INC function are:
Argument Required? Description
array Required The array or range of data that defines relative standing.
k Required The percentile value in the range 0..1, inclusive.
comments powered by Disqus