Google Sheets

PERCENTRANK.INC: Google Sheets Formulae Explained

How do you use PERCENTRANK.INC in Google Sheets?

PERCENTRANK.INC is a function in Google Sheets that calculates the percentage rank of a given value in a list of values. The function takes two arguments: the value to rank, and the list of values to rank it against. It then returns the rank of the value within the list, expressed as a percentage. For example, if you wanted to rank the values in the list 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, the function would return the rank of 5 (50%) within the list.

What is the syntax of PERCENTRANK.INC in Google Sheets?

The syntax of the PERCENTRANK.INC function in Google Sheets is as follows:

=PERCENTRANK.INC(array,percent)

Where:

array is the range of cells containing the data to be ranked percent is the percentage of the highest value in the array to be returned

What is an example of how to use PERCENTRANK.INC in Google Sheets?

The PERCENTRANK.INC function in Google Sheets calculates the rank of a number within a list of numbers, returning the percentage of values that are less than or equal to the input number. To use the function, you first need to enter the numbers you want to compare in a range in a spreadsheet, then use the PERCENTRANK.INC function to calculate the rank of the input number. For example, if you want to find the rank of the number 9 within a list of numbers, you would use the following formula:=PERCENTRANK.INC(A2:A11,9)

When should you not use PERCENTRANK.INC in Google Sheets?

There are several instances in which you should not use PERCENTRANK.INC in Google Sheets. One instance is when you have a list of numbers that are not in order. For example, if you had the numbers 1, 2, 5, and 6, PERCENTRANK.INC would return a value of 2 because 5 is the second number in the list. Another instance is when you have a list of text values. PERCENTRANK.INC will return a value of 0 for text values.

What are some similar formulae to PERCENTRANK.INC in Google Sheets?

PERCENTRANK.INC is a formula used in Google Sheets to calculate the percentage rank of a value in a list of values. This formula is similar to the PERCENTILE.INC formula, which calculates the percentile rank of a value in a list of values. The PERCENTILE.INC formula is similar to the QUARTILE.INC formula, which calculates the quartile rank of a value in a list of values.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.