PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel

PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
PERCENTRANK function - The function returns the rank of the value in Excel

The following article introduces you to PERCENTRANK.INC - one of the functions in the group of statistical functions that is very popular in Excel.

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 1

Description: The function returns the rank of a value in a dataset as a percentage including both values 0 and 1. The function supports Excel 2010 and later versions.

Syntax: PERCENTRANK.INC (array, x, [significance])

Inside:

- array: An array or range of data to determine percentile, which is a required parameter .

- x: The value you want to determine its rank in the dataset, is a required parameter.

- significance: The value determines the number of digits of the percentage value returned, which is an optional parameter, if omitted the default is 3 digits.

Attention:

- If array array value is empty -> the function returns the #NUM! Error value .

- If significance value <1 -> the function returns the #NUM! Error value

- If x does not match any value of the array -> interpolation function to determine the rank of the value.

For example:

Find the rank of the values described in the data table below:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 2

- Calculate the rank of the value 12 in the array. In the cell to calculate enter the formula : = PERCENTRANK.INC (E6: K6, E7)

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 3

- Press Enter -> rank of value 12 in the dataset is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 4

- Calculate the rank of the value 26. In the cell to calculate enter the formula: = PERCENTRANK.INC (E6: K6, E8) -> press Enter -> rank is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 5

Thus, the case with a rank of PERCENTRANK.INC is still calculated normally.

- Calculate the rank of the value 11. In the cell to calculate enter the formula: = PERCENTRANK.INC (E6: K6, E9) -> press Enter -> rank is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel Picture 6

In case the value 11 is not in the value array but it is in the range from 9 to 12 -> the function still calculates normally.

Above are instructions and some specific examples when using PERCENTRANK.INC function in Excel.

Good luck!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
maxa function: the function returns the largest value in a set of values including text and logical values. syntax: maxa (value1, [value2], ...)
MODE.MULT function - The function returns a vertical array of the most common values in Excel
mode.mult function: the function returns a vertical array of the most frequently occurring values, or repeating values in an array or data range. support functions from excel 2010 onwards. syntax: mode.mult ((number1, [number2], ...)
MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
mina function: the function returns the smallest value in the given numbers including text and logical values. syntax: mina (value1, [value2], ...)
How to rank on Excel with RANK function
to rank on excel we will use the rank function. you can rank in ascending or descending order according to your needs.
AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
averagea function: the function returns the average of the arguments including numeric, text, and logical values. syntax: averagea (value1, [value2], ...)
SMALL function - The function returns the kth smallest value in a dataset in Excel
small function: the function returns the kth smallest value in a dataset. syntax: small (array, k)
The use of the RANK function in excel
the rank function is a relatively common function and is widely used in the office world, and especially by accountants. so, what's the rank function for?
MAX function - The function returns the largest value in a set of values in Excel
max function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
How to calculate the percentage change in Pivot Table in Excel
although the main function of a pivottable is to summarize large data, you can use them to calculate the percentage change between values.