PERCENTRANK.INC Function Explained
The PERCENTRANK.INC 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 between 0 and 1, inclusive, representing the rank of the number in the data set as a percentage.
PERCENTRANK.INC Function Syntax
PERCENTRANK.INC(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.