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.