### PERCENTRANK(array, x [,significance])

Returns the percentage rank of a value in an array of numbers (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.* 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!

 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 range9 - What happens when the value you specify is text