We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

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.

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

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)

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.

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.

Get started with Causal today.

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

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