Returns the rank of a value in a dataset as a percentage (0..1, inclusive) of the dataset.
Sample Usage
PERCENTRANKINC(A2:A25,5)
PERCENTRANKINC(A2:A25,5,2)
Syntax
PERCENTRANKINC(range, value, [places])
- range - The range containing the dataset.
- value - The value for which you want to know the rank.
- places - [OPTIONAL] The number of digits to use in the calculation. The default is 3.
Examples
PERCENTRANKINC(A2:A25,5) returns the percent rank of 5 in the range A2:A25.
Notes
- If the value does not fall within the range given for the function, an estimation will be made to bring up a percentage rank for that value.