Excel Functions

Excel PERCENTRANK Function

Pinterest LinkedIn Tumblr

The PERCENTRANK function returns the rank of a value in a data set as a percentage of the data set.

Purpose of Exce PERCENTRANK Function

You can use PERCENTRANK to find the relative standing of a value within a data set. Percentile rank is commonly used as a way to interpret standing in standardized tests.

Return value

Calculated rank as a decimal value.


=PERCENTRANK (array, x, [significance])


arrayArray of data values.Mandatory
xvalue to rank. Mandatory
[significance] A number of significant digits as a result. Defaults to 3.Optional

Usage notes

  • Microsoft classifies PERCENTRANK as a “compatibility function”, now replaced by the PERCENTRANK.INC function.
  • If x does not exist in the array, PERCENTRANK interpolates to find the percentile rank.
  • When significance is omitted PERCENTRANK returns three significant digits.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment