Formulas and functions > Functions from A to Z > PERCENTRANK.INC (percent rank in a data set)

Syntax:

PERCENTRANK.INC(Range, Number [, Digits])

Description:

This returns the percentile rank (between 0 and 1 inclusive) of a value in a data set.

Range is a range with numeric data – usually a reference to a cell range in which numbers are entered.

Number is the value whose rank is to be determined. If Number is not included in the given values, interpolation will be used.

The optional argument Digits lets you specify to how many decimal places the result should be calculated. For this purpose, enter the desired number of decimal places. If omitted, 3 digits will be used.

Example:

If the cells A1:A9 contain the values 1, 2, 3, 4, 5, 6, 7, 8, 9, the following applies:

PERCENTRANK.INC(A1:A9, 5) returns 0.5 (50%) middle of the given values; median

PERCENTRANK.INC(A1:A9, 1) returns 0 (0%) minimum value

PERCENTRANK.INC(A1:A9, 9) returns 1 (100%) maximum value

Note:

The PERCENTRANK.INC and PERCENTRANK.EXC functions supplement the previous PERCENTRANK function.

PERCENTRANK.INC returns the same result as PERCENTRANK (values 0 to 1 inclusive).

PERCENTRANK.EXC (values 0 to 1 exclusive) is completely new.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.