Documentation/Calc Functions/PERCENTRANK.EXC

From The Document Foundation Wiki
Jump to: navigation, search


Under construction.
For now, see the system Help files.

Function name:



Statistical Analysis


Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.


PERCENTRANK.EXC(Data; Value; Significance)



Data represents the array of data in the sample.

Value represents the value whose percentile rank must be determined.

Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.

Additional details:

The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive.


=PERCENTRANK.EXC(A1:A50;50) returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: