MS Excel: PercentRank Function
In Excel, the PercentRank function returns the rank of a value in a set of values as a percentage of the set.
The syntax for the PercentRank function is:
PercentRank( array, value, significant_digits )
array is a range or array from which you want to return the rank.
value is the value that you wish to find the rank for.
significant_digits is optional. It is the number of significant digits to return the rank for. If this parameter is omitted, the PercentRank returns a value that has 3 significant digits (ie: 0.xxx%).
Note:
If significant_digits is less than 1, the PercentRank function will return the #NUM! error.
If value does not exist in the array, the PercentRank function will interpolate to return a percentage rank.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=PercentRank({1,2,3,4}, 3, 2) would return 0.66 =PercentRank({1,2,3,4}, 3) would return 0.666 =PercentRank({1,2,3,4}, 3.5, 2) would return 0.83 =PercentRank(B2:B6, 7, 4) would return 0.2222 =PercentRank({7,8,9,20}, 12) would return 0.757