PERCENTILE
Returns the k-th percentile of values in a range. Replaced by PERCENTILE.INC.
Syntax
PERCENTILE(array, k)
Parameters
- array: Required. The array or range of data that defines relative standing
- k: Required. The percentile value in the range 0..1, inclusive
Example
=PERCENTILE(A1:A10, 0.9)