# PERCENTRANK.INC

PERCENTRANK.INC(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
 * This function was added in Excel 2010 to replace the PERCENTRANK function.* 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.INC function to return the number corresponding to a particular percentage from an array of numbers (inclusive).* You can use the PERCENTRANK.EXC function to return the percentage rank of a value in an array of numbers (exclusive).* 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.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 1) = 0.000 2 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 1.5) = 0 3 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 2) = 0.111 4 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 3) = 0.222 5 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 4) = 0.333 6 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 9) = 0.888 7 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 10) = 1.000 8 =PERCENTRANK.INC({2, 4, 6, 8, 10, 12, 14, 16}, 7) = 0.357 9 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 15) = #N/A 10 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, "some text") = #VALUE! 11 =PERCENTRANK.INC({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 2) = 0

 1 - What is the rank (as a percentage) of the number