Google Sheets

PERCENTILE.EXC: Google Sheets Formulae Explained

How do you use PERCENTILE.EXC in Google Sheets?

PERCENTILE.EXC is used to calculate the percentile rank of a value in a set of data. The function takes in two arguments: the value you want to find the percentile rank for, and an array of data. It will then return the percentile rank of the value you entered, as well as the value's rank in the array.

What is the syntax of PERCENTILE.EXC in Google Sheets?

In Google Sheets, the syntax of PERCENTILE.EXC is as follows:

=PERCENTILE.EXC(array,percent)

This function takes two arguments: an array and a percentage. It returns the percentage of the values in the array that are equal to or greater than the percentage specified.

What is an example of how to use PERCENTILE.EXC in Google Sheets?

The PERCENTILE.EXC function in Google Sheets can be used to calculate the percentile rank of a value in a given set of data. This function takes a single input, which is the value that you want to find the percentile rank for, and returns the percentile rank of that value within the set of data. This function can be used to compare values and find out which ones are in the top or bottom percentiles.

When should you not use PERCENTILE.EXC in Google Sheets?

There are a few occasions when you should not use the PERCENTILE.EXC function in Google Sheets. One such occasion is when you are trying to calculate the percentile rank of a value that is less than zero. In this case, the PERCENTILE.EXC function will return an error. Another time you should not use the PERCENTILE.EXC function is when you are trying to calculate the percentile rank of a value that is greater than or equal to 100. In this case, the PERCENTILE.EXC function will return the value 100.

What are some similar formulae to PERCENTILE.EXC in Google Sheets?

The following are some similar formulae to PERCENTILE.EXC in Google Sheets:

PERCENTILE.INC: Calculates the percentile of a value relative to a given rank.

RANK.AVG: Returns the rank of a number within a list of numbers.

RANK.EQ: Returns the rank of a number within a list of numbers, treating ties as equal.

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.