PERCENTRANK

Try it

When to use it

When should I use PERCENTRANK?

Use PERCENTRANK to find the relative standing of a specific value within a dataset as a percentage — for example, what percentile a student's score falls in, or where a product's price sits relative to competitors. The result is a value from 0 to 1.

Used in

education · operations

Syntax

PERCENTRANK(array,x,[sig])

Examples

=PERCENTRANK({1,2,3,4,5},1) // => 0
=PERCENTRANK({1,2,3,4,5},3) // => 0.5
=PERCENTRANK({1,2,3,4,5},2,7) // => 0.25