Excel Function 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

* Added in Excel 2010.
* For an illustrated example refer to the page under Advanced Functions
* This function replaces the PERCENTILE function.
* 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.
* 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!