Statistical - PERCENTRANK.EXC Function

Description

The PERCENTRANK.EXC function returns the rank of a value in a data set as a percentage (0...1, exclusive) of the data set.

PERCENTRANK.EXC (array,x,[significance])

Argument	Description	Required/ Optional
Array	The array or range of data with numeric values that defines relative standing.	Required
X	The value for which you want to know the rank.	Required
Significance	A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).	Optional

Argument

Description

Required/ Optional

Array

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

Required

The value for which you want to know the rank.

Required

Significance

A value that identifies the number of significant digits for the returned percentage value.

If omitted, PERCENTRANK.EXC uses three digits (0.xxx).

Optional

If x does not match one of the values in array, PERCENTRANK.EXC interpolates to return the correct percentage rank.
If array is empty, PERCENTRANK.EXC returns the #NUM! error value.
If significance < 1, PERCENTRANK.EXC returns the #NUM! error value.
If x is smaller than the minimum, or greater than the maximum value in the supplied array, PERCENTRANK.EXC returns the #N/A error value.

Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm