PERCENTILE.EXC

PERCENTILE.EXC(array, k)

Returns the value from a data set that corresponds to a particular percentage (exclusive).

array	The array or range of numbers.
k	The percentage you are looking for between 0 and 1 (exclusive)

REMARKS

* 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.
* This function only works if k is between 1/(+1)n and 1-1/(n+1), where n is the number of elements in array. When there are 5 values, 1-1/(n+1)=.83333, so it fails when you choose a value of 0.95. Similarly it fails if k<0.166667
* If "k" is not a multiple of 1/(n-1) then interpolation is used to calculate the percentile.
* 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.EXC function to return the fixed percentiles of 0, 25, 50, 75 and 100 (exclusive).
* This function was added in Excel 2010 to replace the PERCENTILE function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=PERCENTILE.EXC({1, 2, 3, 4}, 0.3) = 1.5
2	=PERCENTILE.EXC({1, 2, 3, 4}, 0.33) = 1.7
3	=PERCENTILE.EXC({1, 2, 3, 4}, 0.9) = #NUM!
4	=PERCENTILE.EXC({1, 2, 3, 4}, 0) = #NUM!
5	=PERCENTILE.EXC(, 0.3) = #NUM!
6	=PERCENTILE.EXC({1, 2, 3, 4}, 2) = #NUM!
7	=PERCENTILE.EXC({1, 2, 3, 4}, "some text") = #VALUE!