Manuals/calci/PERCENTRANK

PERCENTRANK(Array, X ,k)

where,

Array - represents set of data.

X - represents the rank for value.

k - represents the number of significant digit for the returned percentage value.If omitted, it returns 3 digit after decimal point.

It returns the rank for data set as a percentage of the data set.

If k < 1, PERCENTRANK returns the #ERROR.

PERCENTRANK

Lets see an example in (Column2, Row1)

=PERCENTRANK(R1C1:R6C1, 4)

PERCENTRANK returns 0.66667.

Cosider an another example

=PERCENTRANK([1,2,3,4,5,6], -1)

It returns #ERROR(K=-1).

Syntax

Remarks

Examples

Description