Check Sheet Logo
Check Sheet


The PERCENTRANK.INC function calculates the rank of a value in a dataset as a percentage between 0 and 1, inclusive. This function is commonly used in statistical analysis to determine the relative standing of a value within a dataset.


Use the PERCENTRANK.INC formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

=PERCENTRANK.INC(data, value, [significant_digits])
  1. data (required):
    The array or range of cells representing the dataset that the value will be ranked against.
  2. value (required):
    The value to be ranked within the dataset.
  3. significant_digits (optional):
    An optional parameter that specifies the number of significant digits to use in the calculated result. If omitted, the default value is 3.


Here are a few example use cases that explain how to use the PERCENTRANK.INC formula in Google Sheets.

Calculate percentile rank of a value in a dataset

Use PERCENTRANK.INC to determine the percentile rank of a given value in a dataset. This can be useful for analyzing the distribution of data and identifying outliers.

Rank students based on test scores

Use PERCENTRANK.INC to rank students based on their test scores. This can be useful for identifying the highest and lowest performing students in a class.

Analyze sales performance by region

Use PERCENTRANK.INC to analyze sales performance by region. This can be useful for identifying regions with the highest sales and identifying areas for improvement.

Common Mistakes

PERCENTRANK.INC not working? Here are some common mistakes people make when using the PERCENTRANK.INC Google Sheets Formula:

Using an incorrect range

One common mistake when using the PERCENTRANK.INC function is selecting an incorrect range of values. Make sure the range includes all of the values you want to analyze, and that the range is properly formatted with commas separating values and semicolons separating rows.

Omitting the value parameter

The PERCENTRANK.INC function requires two parameters: the dataset to be analyzed and the value for which you want to determine the percentage rank. Forgetting to include the value parameter will result in an error.

Using a sample instead of a population

The PERCENTRANK.INC function assumes that the supplied dataset represents the entire population, rather than a sample. If you are working with a sample, you should use the PERCENTRANK.EXC function instead.

The following functions are similar to PERCENTRANK.INC or are often used with it in a formula:


    RANK.AVG is a statistical function that returns the rank of a specified value within a dataset. The rank is determined by comparing the value to the other values in the dataset. This function is commonly used to determine the relative position of a value within a range of values.


    The RANK.EQ function returns the rank of a specified value in a list of numbers. The rank of a number is its size relative to other values in the list. It is often used to determine the relative standing of values in a dataset. The function can be used to rank values in ascending or descending order, and can handle ties in several ways.


    The PERCENTILE.INC function returns the k-th percentile of a dataset, where k is a value between 0 and 1, inclusive. It returns an interpolated value if the percentile falls between two data points. This function is commonly used in statistical analysis.


    The QUARTILE.INC function calculates the quartile of a dataset, which is a measure of statistical dispersion. It is commonly used to split a dataset into four equal parts, each containing 25% of the data points. The function takes in two parameters - the dataset as data and the quartile number as quartile_number - and returns the value of the specified quartile. Quartile numbers are specified as follows: 1 for the first quartile (25th percentile), 2 for the second quartile (50th percentile, or median), and 3 for the third quartile (75th percentile).


    The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

Learn More

You can learn more about the PERCENTRANK.INC Google Sheets function on Google Support.