Excel PERCENTRANK.EXC function

Function              PERCENTRANK.EXC

Description        Excel PERCENTRANK.EXC function returns the rank (0 to 1 exclusive) of a value from a data set as a percentile of the data set.

Syntax  PERCENTRANK.EXC(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.EXC returns the #NUM! error value.