PERCENTRANK(array, x [,significance])

Returns the percentage rank of a value in an array of numbers (inclusive).

arrayThe array of values.
xThe value for which you want to know the rank.
significance(Optional) The number of significant digits for the returned percentage value.

Remarks

* PERCENTRANK.INC was added in Excel 2010 to replace this function.
* Returns the rank of a value in a data set as a percentage of the data set.
* If "array" is empty, then #NUM! is returned.
* If "significance" < 1, then #NUM! is returned.
* If "significance" is left blank", then 3 is used (i.e. 0.xxx%).
* If "x" does not match one of the values in array, the functions interpolates to return the correct percentage rank.
* This function can be used to evaluate the relative standing of a value within a data set.
* PERCENTRANK.EXC was added in Excel 2010 to handle the percentile value in an exclusive range.
* For the Microsoft documentation refer to support.office.com

 A
1=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},1) = 0
2=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},1.5) = 0.055
3=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},2) = 0.111
4=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},3) = 0.222
5=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},4) = 0.333
6=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},10) = 1
7=PERCENTRANK({2,4,6,8,10,12,14,16},7) = 0.357
8=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},15) = #N/A
9=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!

Example 1 - What is the rank (as a percentage) of the number 1 in the array (1,2,3,4,5,6,7,8,9,10).
Example 2 - What is the rank (as a percentage) of the number 1.5 in this array.
Example 3 - What is the rank (as a percentage) of the number 2 in this array.
Example 4 - What is the rank (as a percentage) of the number 3 in this array.
Example 5 - What is the rank (as a percentage) of the number 4 in this array.
Example 6 - What is the rank of the number 1 in this array.
Example 7 - What is the rank of the number 7 in the array (2,4,6,8,10,12,14,16)
Example 8 - What happens when the value you specify is outside the range
Example 9 - What happens when the value you specify is text

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top