PERCENTILE.INC

Returns a percentile value from a data set.

Syntax:

PERCENTILE.INC(array, k:number)

Returns the (100*k)th percentile from the values in the array or range of cells.

k must be a decimal fraction in the range [0.0,1.0].

Added in 1.36.