PERCENTRANK_EXC

PERCENTRANK_EXC(arg1, arg2, arg3) → { number }

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

Parameters:

Name Type Description
arg1 Array.<number> | ApiRange

The array or range of data with numeric values that defines relative standing.

arg2 number

The value for which the rank will be returned.

arg3 number

An optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%).

Returns:

Type
number