How to Use the PERCENTILE Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Intermediate · 5 min read · includes 2 free exercises

In short: PERCENTILE returns the value at a given percentile of a data set. The formula is =PERCENTILE(data, percentile). A percentile of 0.5 gives the same result as MEDIAN.

What PERCENTILE does

A percentile tells you where a value sits in a data set. The 90th percentile is the value that 90% of the data falls at or below. Teachers use it for test scores, and analysts use it for response times, where an average hides the slow cases. For the middle value on its own, see MEDIAN.

PERCENTILE syntax

=PERCENTILE(data, percentile)

Google's help page makes two points. The result may not be a value that appears in data, because the function interpolates between values. And setting percentile to 0.5 gives the same result as MEDIAN on the same data. The page does not describe the exact interpolation method, so check unusual cases against your own data.

A step-by-step example

Here are five scores in cells A1:A6.

A
1Score
210
320
430
540
650
=PERCENTILE(A2:A6, 0.5)

This returns 30, the same as =MEDIAN(A2:A6), because the 50th percentile is the median.

=PERCENTILE(A2:A6, 0.9)

This returns a value near the top of the list. Because the function interpolates, the answer can fall between two scores.

Common mistakes

Try it yourself

Use the scores above (A2:A6). Type your formula into the box, starting with =, then press Check.

Exercise 1: The 50th percentile

Write a formula that returns the 50th percentile of A2:A6.

Hint: the percentile is written as 0.5.

Exercise 2: The 90th percentile

Write a formula that returns the 90th percentile of A2:A6.

Hint: use a decimal, not 90.

What to learn next

Syntax and rules in this guide were checked against Google's PERCENTILE help page. See all guides.