PERCENTRANK function

PERCENTRANK(Array, Number, Significance?) PERCENTRANK(Array; Number; Significance?)

Array

{ Number }

An unordered array of data.

Number

Number or { Number }

The value, found in the given array, whose rank should be determined.

Significance

Number or { Number } (optional)

The number of significant digits for the result value. If omitted, 3 is assumed.

Returns

Number or { Number }

The percentage rank of a number in a list of numbers.

This function is a compatibility alias for PERCENTRANK.INC. Use PERCENTRANK.INC for new projects.