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

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

Syntax: PERCENTILE.EXC(array, k)

#1)
The arguments for the PERCENTILE.EXC 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, exclusive.
comments powered by Disqus