Excel Functions

Excel PERCENTRANK.INC Function

Pinterest LinkedIn Tumblr

The Excel PERCENTRANK.INC Function calculates the relative position between 0 and 1 inclusive,within a supplied array.In MS Excel PERCENTRANK.INC is categorized under statistical function.

Purpose of Excel PERCENTRANK.INC Function

To get 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.

Return value

PERCENTRANK.INC returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.

Syntax

= PERCENTRANK.INC(array,x,[significance])

Arguments

ArgumentsDescriptionRemarks
array A range or array from which you want to return the rank. Mandatory
xThe value that you wish to find the rank for. Mandatory
[significance]Number of significant digits in result. Defaults to 3.Optional

Usage notes

  • N/A error will Occur if the supplied value of x is smaller than the minimum, or greater than the maximum value in the supplied array.
  • NUM!error will occur if the supplied [significance] value is < 1.
  • NUM!error will occur if the supplied array is empty.

Availability

Since 2010 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment