PERCENTRANK Function Explained
The PERCENTRANK Function in Microsoft Excel calculates the rank of a value in a data set as a percentage of the data set. It returns a number between 0 and 1, inclusive, representing the rank of the value in the data set as a percentage. It takes two arguments: an array of values and the value to be ranked.
PERCENTRANK Function Syntax
PERCENTRANK(array, x, [significance])
- array: The array of data to consider when calculating the percentile rank.
- x: The value for which you want to calculate the percentile rank.
- significance: (optional) The number of significant digits to which you want to round the result. If omitted, the default value is 3.