PERCENTRANK

PERCENTRANK(array, x [,significance])

Returns the rank of a value as a percentage (inclusive).

array	The array of values.
x	The 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.
* You can use the PERCENTILE.INC function to return the number corresponding to a particular percentage from an array of numbers (inclusive).
* You can use the QUARTILE.INC function to return the quartile of a data set (inclusive).
* You can use the RANK.EQ function to return the rank of a value in descending order (equal ranking).
* You can use the RANK.AVG function to return the rank of a value in descending order (average ranking).
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!

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