# PERCENTRANK.EXC

PERCENTRANK.EXC(array, x [,significance])

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

 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
 * 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.* You can use the PERCENTILE.EXC function to return the number corresponding to a particular percentage from an array of numbers (exclusive).* 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 PERCENTRANK.INC function to return the percentage rank of a value in an array of numbers (inclusive).* This function was added in Excel 2010* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1) = 0.090 2 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1.5) = 0 3 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},2) = 0.181 4 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},3) = 0.272 5 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},4) = 0.363 6 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},9) = 0.818 7 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},10) = 0.909 8 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},15) = #N/A 9 =PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!