Related Functions:

The PERCENTRANK.INC function returns the relative position, between 0 and 1, inclusive, of a specified value within a supplied array.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The PERCENTRANK.INC function replaces the PERCENTRANK function included in earlier versions of Excel.

Syntax

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

Arguments

Argument Description
array The array or range of data with numeric values that defines relative standing
x The specific value that you want to calculate the relative position of

  x must be within the range of the values in the supplied array, but it does not need to be exactly equal to one of the values
[significance] Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (0.xxx)

Examples

  A B C D
1 Data      
2 1      
3 3      
4 4      
5 7.5      
6 8      
7 8      
8 9      
9 10      
10 10      
11        
12 Formula Result Notes
13 =PERCENTRANK.INC(A2:A10,5) 0.285 Percent rank of 5 in the range A2:A10
14 =PERCENTRANK.INC(A2:A10,5,2) 0.28 Percent rank of 5 in the range A2:A10 to 2 digits

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied x is smaller than the minimum, or greater than the maximum value in the supplied array

  the supplied [significance] value is < 1
  the supplied array is empty
#N/A Occurs when Analysis ToolPak add-in is not enabled