Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetFunction.PercentRank_Inc Method (Excel)

Published: July 16, 2012

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 Added: Excel 2010

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

  • 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.