Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

PERCENTRANK.EXC

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

 

Sample Usage

PERCENTRANK.EXC(A2:A25,5)
PERCENTRANK.EXC(A2:A25,5,2)

Syntax

PERCENTRANK.EXC(range, value, [places])

  • range - The range containing the dataset.
  • value - The value for which you want to know the rank.
  • places - [OPTIONAL] The number of digits to use in the calculation. The default is 3.

 

Examples

PERCENTRANK.EXC(A2:A25,5) returns the percent rank of 5 in the range A2:A25.
 

Notes

  • If the value does not fall within the range given for the function, an estimation will be made to bring up a percentage rank for that value.