WorksheetFunction.PercentRank_Inc (Excel)

Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PercentRank_Inc to evaluate the standing of an aptitude test score among all scores for the test.

If array is empty, PercentRank_Inc returns the #NUM! error value. If significance < 1, PercentRank_Inc returns the #NUM! error value. If x does not match one of the values in array, PercentRank_Inc interpolates to return the correct percentage rank.

PercentRank_Inc (Arg1, Arg2, Arg3)


Dim dblArg2 As Double: dblArg2 = 
Dim dblPercentRank_Inc As Double
dblPercentRank_Inc = WorksheetFunction.PercentRank_Inc(Arg1:=, Arg2:=dblArg2)

Arguments

Arg1, Arg2, Arg3

Arg1 - Array - The array or range of data with numeric values that defines relative standing

Arg2 (Double) - X - The value for which you want to know the rank.

Arg3 - Significance - An optional value that identifies the number of significant digits for the returned percentage value. If omitted, PercentRank_Inc uses three digits (0.xxx)