Excel PERCENTRANK Function

Using the Excel PERCENTRANK Function


The Excel PERCENTRANK function returns the rank of a value contained in a data set as a percentage of the data set. This function is useful when evaluating the relative standing of a value within a data set. For example, PERCENTRANK could be used to evaluate the standing of an aptitude test score among all scores recorded for the test.

PERCENTRANK is currently available as a compatibility function. Microsoft recommends using the PERCENTRANK.EXC function or PERCENTRANK.INC function for improved accuracy.


=PERCENTRANK (array, x, [significance])

Syntax Breakdown

Required. An array or range of data with numeric values that defines the relative standing.

Required. The specific value for which you want to find the rank.

Optional. The number of significant digits for the returned percentage value. If omitted, the function uses three digits (0.xxx).

Usage Notes

PERCENTRANK returns the relative standing of a value within a data set, shown as a percentage. For example, if you had a score better than 90% of all scores it would be in the 90th percentile (see the PERCENTILE function). PERCENTRANK would provide the score with a rank of 0.90.

If the value specified in the X argument is not found in array, the function interpolates to return the correct percentage rank.

The PERCENTRANK function returns the #NUM! error in the following instances:
  • If array is empty;
  • If significance < 1