# PERCENTILE.INC

PERCENTILE.INC(array,k)

Returns the number corresponding to a particular percentage from an array of numbers (inclusive).

 array The array or range of numbers. k The percentile between 0 and 1 (inclusive)

 REMARKS
 * This function was added in Excel 2010 to replace the PERCENTILE function.* For an illustrated example refer to the page under Advanced Functions* If "array" is empty, then #NUM! is returned.* If "k" is not numeric, then #VALUE! is returned.* If "k" < 0, then #NUM! is returned.* If "k" < 1, then #NUM! is returned.* If "k" is not a multiple of 1/(n-1) then interpolation is used to calculate the percentile.* 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 PERCENTRANK.INC function to return the percentage rank of a value in 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 fixed percentiles of 0, 25, 50, 75 and 100 (inclusive).* You can use the QUARTILE.EXC function to return the fixed percentiles of 0, 25, 50, 75 and 100 (exclusive).* For the Microsoft documentation refer to support.microsoft.com

 A 1 =PERCENTILE.INC({1,2,3,4},0.3) = 1.9 2 =PERCENTILE.INC({1,2,3,4},0.33) = 2.0 3 =PERCENTILE.INC({1,2,3,4},0.9) = 3.7 4 =PERCENTILE.INC({1,2,3,4},0) = 1 5 =PERCENTILE.INC(,0.3) = 0 6 =PERCENTILE.INC({1,2,3,4},2) = #NUM! 7 =PERCENTILE.INC({1,2,3,4},"some text") = #VALUE!