PERCENTRANK.INC Function

The PERCENTRANK.INC 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, inclusive) of the data set.

Syntax

PERCENTRANK.INC(array, x, [significance])

The PERCENTRANK.INC 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.INC function.

Examples

The figure below displays the result returned by the PERCENTRANK.INC function.