# Documentation/Calc Functions/PERCENTRANK.EXC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

PERCENTRANK.EXC

## Category:

Statistical Analysis

## Summary:

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

## Syntax:

PERCENTRANK.EXC(**Data**; **Value**; **Significance**)

## Returns:

## Arguments:

**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.

## Examples:

=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.