Functions
PERCENTRANK.INC
Inclusive percentile rank
Try it
When to use it
When should I use PERCENTRANK.INC?
Use PERCENTRANK.INC when you need an inclusive percentile rank that can return 0 for the minimum value and 1 for the maximum value in the dataset, which is standard for grading on a curve or comparing scores within a fixed range.
Used in
Syntax
PERCENTRANK.INC(array,x,[sig])Examples
=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},5) // => 0.444
=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},3,4) // => 0.2222
=PERCENTRANK.INC({10,20,30,40,50},10) // => 0