Skip to Content

PERCENTILE.INC

Returns the k-th percentile of values in a range

Syntax

PERCENTILE.INC(array, k)

Parameters

  • array: Required. The array or range of data
  • k: Required. The percentile value between 0 and 1, inclusive

Example

=PERCENTILE.INC(A1:A10, 0.9)
Returns: NumberSince: Excel 2010