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.
Version Information
Version Added: Excel 2010
Syntax
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
Remarks
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.