PERCENTRANK.INC

Using the Excel PERCENTRANK.INC Function

Summary

The Excel PERCENTRANK.INC function returns the rank of a value contained in a data set as a percentage inclusive of the data set. This function is useful when evaluating the relative standing of a value within a data set. For example, PERCENTRANK.INC could be used to evaluate the standing of students who have taken a standardized test.

The PERCENTRANK.INC function, along with the PERCENTRANK.EXC function, are provided by Microsoft as a replacement for the PERCENTRANK function and may provide improved accuracy.


Syntax

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

Syntax Breakdown

Array
Required. An array or range of data with numeric values that defines the relative standing.

X
Required. The specific value for which you want to find the rank.

Significance
Optional. The number of significant digits for the returned percentage value. If omitted, the function uses three digits (0.xxx).


Usage Notes

PERCENTRANK.INC returns the relative standing of a value within a data set, shown as a percentage. For example, if you had a score better than 90% of all scores it would be in the 90th percentile (see the PERCENTILE function). PERCENTRANK.INC would provide the score with a rank of 0.90.

If the value specified in the X argument is not found in array, the function interpolates to return the correct percentage rank.

Inclusive vs. Exclusive
In Excel 2010, Microsoft replaced the PERCENRANK function with PERCENTRANK.EXC and PERCENTRANK.INC. The "EXC" indicates exclusive and "INC" indicates inclusive. Both formulas use the same arguments.

PERCENTRANK.EXC should be used when you must determine the rank exclusive of the first and last values in the array.

PERCENTRANK.INC. should be used when you must determine the rank inclusive of the first and last values in the array.

The following screen shot shows the difference between the two when using a small data set. Users should note, however, that as the size of the input array increases, the difference between the EXC and INC functions will decrease.

Excel PERCENTRANK EXC vs INC

Errors
The PERCENTRANK.INC function returns the #NUM! error in the following instances:
  • If array is empty;
  • If significance < 1