WorksheetFunction.PercentRank_Inc Method (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.
expression .PercentRank_Inc(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
Name | Required/Optional | Data Type | Description |
|---|---|---|---|
Arg1 | Required | Variant | Array - The array or range of data with numeric values that defines relative standing. |
Arg2 | Required | Double | X - The value for which you want to know the rank. |
Arg3 | Optional | Variant | 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). |
Return Value
Double
