PERCENTRANK

Returns the percentage rank (percentile) of a specified value in a dataset. Learn more

Video field
Statistical

In Google Sheets, the PERCENTRANK function calculates the rank of a specified value within a dataset as a percentile.

The formula syntax for PERCENTRANK is as follows:

PERCENTRANK(data, value, [significant_digits])

data represents the range or array of values in which you want to calculate the percentile.

value is the value for which you want to determine the rank.

significant_digits specifies the number of significant digits for the percentile calculation. If omitted, it defaults to 3.

The PERCENTRANK function returns a decimal value between 0 and 1, representing the rank of the specified value in the dataset.

This value indicates the percentage of values in the dataset that are less than or equal to the specified value.

Here's an example to illustrate the usage of PERCENTRANK in Google Sheets:

=PERCENTRANK(A1:A10, 5, 2)

In this example, the formula calculates the percentile rank of the value 5 within the range A1:A10 with two significant digits.

The returned value will be a decimal representing the percentage rank of 5 compared to the other values in the dataset.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!