# PERCENTRANK.INC

Formulas / PERCENTRANK.INC
Calculate the relative rank of a value in a data set as a percentage.
`PERCENTRANK.INC(array, x, [significance])`
• array - required, an array of data values
• x - required, the value to rank
• significance - [OPTIONAL] number of significant digits in the result

## Examples

The function can be used to find a given value's rank in a range of values. For example, if the range A2:A11 contains the values 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10, then the PERCENTRANK.INC function can be used to calculate the percent rank of 2 in the range. The formula would return 0.333. This is because 3 of the values in the range are smaller than 2, and 6 of the values in the range are larger than 2; 3 divided by (3+6) is 0.333.

• `=PERCENTRANK.INC(A2:A11,8)`

The function can also be used to find the percent rank of a value that is not among the values in the range. For example, if the range A2:A11 contains the values 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10, then the PERCENTRANK.INC function can be used to calculate the percent rank of 8 in the range. The formula would return 0.889. This is because 8 is the 8th value in the range when counting from the leftmost column.

## Summary

The PERCENTRANK.INC function is used to calculate the relative rank of a value within a data set. It returns the rank of a value as a percentage of the whole set and can interpolate if the value does not match one of the values in the array. It returns a #NUM! error if the array is empty.

• The PERCENTRANK.INC function calculates the relative rank of a value in a data set as a percentage, which is used to interpret standing in standardized tests. The arguments for this function are array (required), x (required), and significance (optional). It will calculate the rank as a decimal value.

What is the PERCENTRANK.INC function?
The PERCENTRANK.INC function is used to return the rank of a value in a data set as a percentage of all values in the data set.
How does the PERCENTRANK.INC function work?
The PERCENTRANK.INC function takes two arguments; an array of values and a number that is to be evaluated against the array. The function returns the rank of the number as a percentage of all values in the array.
What happens if the array argument is empty?
The PERCENTRANK.INC function will return a #NUM! error if the array argument is empty.
Can the PERCENTRANK.INC function interpolate?
Yes, the PERCENTRANK.INC function can interpolate to return the correct percentage rank if the x argument does not match one of the values in the array. 