← All functions

PERCENTILE.EXC

Quirk found

Category: Statistical · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	Yes	Yes (24.2.7.2, 2026-07-04)	Quirk found

Discovered quirks

=PERCENTILE.EXC(A1:A10,0) on LibreOffice Calc returned #VALUE!, but the documented/expected result is #NUM!. MISMATCH vs expected: expected '#NUM!', got '#VALUE!'
=PERCENTILE.EXC(A1:A10,1) on LibreOffice Calc returned #VALUE!, but the documented/expected result is #NUM!. MISMATCH vs expected: expected '#NUM!', got '#VALUE!'

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

Formula	Description	Result	Expected	Verdict
=PERCENTILE.EXC(A1:A10,0)	Documented divergence from PERCENTILE.INC: PERCENTILE.EXC requires k strictly between 0 and 1 (and more precisely between 1/(n+1) and n/(n+1)); k=0 -> #NUM!. Confirmed via Microsoft's PERCENTILE.EXC docs (https://support.microsoft.com/en-us/office/percentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba): "If k is <=0 or if k >=1, PERCENTILE.EXC returns the #NUM! error value." PERCENTILE.INC_k_zero on identical data returns 1, not an error.	#VALUE!	#NUM!	Mismatch
=PERCENTILE.EXC(A1:A10,1)	k=1 is likewise out of PERCENTILE.EXC's exclusive valid range -> #NUM!, whereas PERCENTILE.INC_k_one on identical data returns 10	#VALUE!	#NUM!	Mismatch
=PERCENTILE.EXC(A1:A10,0.5)	k=0.5 is within the valid range for n=10 (1/11 < 0.5 < 10/11) and matches PERCENTILE.INC's result at the median	5.5	5.5	Matched
=PERCENTILE.EXC(A1:A10,0.1)	k=0.1 is valid since 1/(n+1)=1/11=0.0909 < 0.1 < 10/11=0.9091 for n=10	1.1	1.1 pos=k(n+1)=0.111=1.1 -> interpolate 10% of the way from data[0]=1 to data[1]=2 -> 1.1	Matched

Docs & syntax

Excel: official documentation
Google Sheets: official documentation
LibreOffice Calc: official documentation