PERCENTRANK.EXC

Calculates the percentage rank of a value in a data set.

Syntax:

PERCENTRANK.EXC( data:Range or Array, value:Number, digits:PositiveInteger )

Returns the percentage rank in (0.0..1.0) (i.e. exclusive) of the value in the data range of cells (or array) to the number of decimal places specified by digits (default is 3).

Revisions:

This function was added in Fireworkz 2.00.