PERCENTRANK(R, N)

 

Description

This function returns the percentile rank of the number N among the values in the range R.

 

Parameters

 

R

A range of data.

 

N

A number. The function finds the percentile rank of this number.

 

Examples

 

PERCENTRANK(A1:A6, 4.5) = 0.7

Where A1:A6 = 1, 2, 3, 4, 5, 6.

 

PERCENTRANK(B1:B6, 21.35) = 0.77

Where B1:B8 = 3.8, 23, 4, 12, 67, 0.2.