Skip to main content
Windward

PERCENTILE.INC Function

Overviewautotag-wiki-logo.png

The PERCENTILE.INC function

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

For example

=Percentile.inc(1,3,2,4,0.3) returns 1.9

Syntax

PERCENTILE.INC(number1,number2,...,k)
  • ​number - At least one required. Group of value that defines relative standing.
  • K - Required. The percentile value in the range 0..1, inclusive.

  • Was this article helpful?