Compatibility - PERCENTRANK Function
The PERCENTRANK function replaces the PERCENTRANK.INC function in Excel 2010.
Description
The function returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set.
Syntax
PERCENTRANK (array,x,[significance])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Array | The array or range of data with numeric values that defines relative standing. | Required |
X | The value for which you want to know the rank. | Required |
Significance | A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK uses three digits (0.xxx). |
Optional |
Notes
If x does not match one of the values in array, PERCENTRANK interpolates to return the correct percentage rank.
If array is empty, PERCENTRANK returns the #NUM! error value.
If significance < 1, PERCENTRANK returns the #NUM! error value.