PERCENTRANK function
The PERCENTRANK function is one of the statistical functions. It is used to return the rank of a value in a set of values as a percentage of the set.
Syntax
PERCENTRANK(array, x, [significance])
The PERCENTRANK 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 function.
Examples
The figure below displays the result returned by the PERCENTRANK function.
