Excel PERCENTRANK function

Function              PERCENTRANK

Description        Excel PERCENTRANK function returns the rank of a value from a data set as a percentile of the data set.

Syntax  PERCENTRANK(array, x, [significance])

array  set of data values.

x  value to be ranked.

significance  [optional] Number of significant digits in result. Default it is 3.

Example:

Usage Notes:

• If the value of x is lower than the lowest value in data set then it returns #NUM! error.
• If the value of x is higher than the highest value in data set then it returns #NUM! error.
• If the array is empty then it returns #NUM! error.
• If significance < 1, PERCENTRANK returns the #NUM! error value.