The PERCENTRANK function returns the rank of a value in a data set as a percentage of the data set.
Purpose of Exce PERCENTRANK Function
You can use PERCENTRANK to find the relative standing of a value within a data set. Percentile rank is commonly used as a way to interpret standing in standardized tests.
Return value
Calculated rank as a decimal value.
Syntax
=PERCENTRANK (array, x, [significance])
Arguments
| Arguments | Description | Remarks |
| array | Array of data values. | Mandatory |
| x | value to rank. | Mandatory |
| [significance] | A number of significant digits as a result. Defaults to 3. | Optional |
Usage notes
- Microsoft classifies PERCENTRANK as a “compatibility function”, now replaced by the PERCENTRANK.INC function.
- If x does not exist in the array, PERCENTRANK interpolates to find the percentile rank.
- When significance is omitted PERCENTRANK returns three significant digits.
Availability
Since 2007 for Windows.
Since 2011 for Mac.