Skip to main content
Windward

PERCENTILE.EXC Function

Overviewautotag-wiki-logo.png

The PERCENTILE.EXC function

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

For example

=Percentile.exc(1,2,3,6,6,6,7,8,9,0.8) returns 8.0

Syntax

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

  • Was this article helpful?