Excel PERCENTRANK.INC function

Function              PERCENTRANK.INC

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

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