Skip to main content
Windward

Percentilerank.INC Function

Overviewautotag-wiki-logo.png

The Percentilerank.INC function

Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.

For example

=Percentilerank.inc(1,2,4,6.5,8,9,10,12,14,8) returns 0.5

Syntax

PERCENTILERANK.INC(number1,number2,...,x)
  • ​number - At least one required. Group of values that defines relative standing.
  • k - Required. The percentile value in the range 0..1, inclusive.
  • Was this article helpful?