PERCENTRANK.EXC function
The PERCENTRANK.EXC function is one of the statistical functions. It is used to return the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
Syntax
PERCENTRANK.EXC(array, x, [significance])
The PERCENTRANK.EXC function has the following arguments:
| Argument | Description |
|---|---|
| array | The selected range of cells containing the numeric values. |
| x | The value you want to find the rank for, a numeric value. |
| significance | The number of significant digits to return the rank for. It is an optional argument. If it is omitted, the function will assume significance to be 3. |
Notes
How to apply the PERCENTRANK.EXC function.
Examples
The figure below displays the result returned by the PERCENTRANK.EXC function.
