Author: Oscar Cronquist Article last updated on November 28, 2018

The PERCENTRANK.INC function calculates the percent rank of a given number in a data set.

This function was introduced in Excel 2010 and has replaced the PERCENTRANK function.

Formula in cell C7:

=PERCENTRANK.EXC(B3:B17,11)

Excel Function Syntax

PERCENTRANK.EXC(arrayx[significance])

Arguments

array Required. A parameter which determines the shape of the distribution.
x Required. A parameter which determines the shape of the distribution.
[significance] Optional. Number of significant digits of the returned value, default value 3.

Comments

The PERCENTRANK.EXC function returns

  • #NUM! error value if:
    • array is empty
    • [significance] < 1

The PERCENTRANK.EXC function interpolates in order to return the correct value if x doesn't match a value in the array.