PERCENTRANK.EXC Function Explained
The PERCENTRANK.EXC Function in Microsoft Excel calculates the rank of a value in a data set as a percentage of the data set. It takes two arguments: an array of, or reference to, a list of numbers and a number for which you want to calculate the rank. It returns a number representing the rank of the number in the list as a percentage.
PERCENTRANK.EXC Function Syntax
PERCENTRANK.EXC(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.