PERCENTILE.EXC

Try it

When to use it

When should I use PERCENTILE.EXC instead of PERCENTILE.INC?

Use PERCENTILE.EXC when you need the exclusive percentile, where k must be strictly between 0 and 1 (endpoints excluded). This matches some statistical conventions — for example, rank-based methods that treat boundary percentiles as undefined.

Used in

science · operations

Syntax

PERCENTILE.EXC(array,k)

Examples

=PERCENTILE.EXC({15,20,35,40,50},0.4) // => 26.000000000000007
=PERCENTILE.EXC({15,20,35,40,50},0.5) // => 35
=PERCENTILE.EXC({15,20,35,40,50},0.8) // => 48.00000000000001