Functions
PERCENTILE.INC
Inclusive percentile
Try it
When to use it
When should I use PERCENTILE.INC?
Use PERCENTILE.INC when you want the inclusive percentile where k=0 returns the minimum and k=1 returns the maximum. It is identical to PERCENTILE and is the modern preferred name — use it in new work instead of the bare PERCENTILE alias.
Used in
Syntax
PERCENTILE.INC(array,k)Examples
=PERCENTILE.INC({1,2,3,4,5,6,7,8,9,10},0.5) // => 5.5
=PERCENTILE.INC({1,2,3,4,5,6,7,8,9,10},0.67) // => 7.03