In this article:

Quartile Function in Google Sheets (Easiest Way to Use It in 2024)

May 8, 2024

Quartile in Google Sheets

In Google Sheets, the quartile function is used to calculate the quartile of a dataset, which is a type of quantile. The function can be used to find the value below which a certain percentage of data falls. Quartiles divide a rank-ordered data set into four equal parts. The three quartiles are first quartile (Q1), second quartile (Q2), and third quartile (Q3) which correspond to the 25th, 50th, and 75th percentiles, respectively.

Quartile Function in Google Sheets

The syntax of the quartile function in Google Sheets is as follows:

QUARTILE(data, quart)

  • data is the array or range containing the dataset to consider.
  • quart specifies which quartile to return and can take the following values:
    • 0 for the minimum value,
    • 1 for the first quartile (25th percentile),
    • 2 for the median or second quartile (50th percentile),
    • 3 for the third quartile (75th percentile),
    • 4 for the maximum value.

How to Use the Quartile Formula in Google Sheets

Follow the steps below to use the Quartile formula in Google Sheets. 

1. Input Data into Google Sheets

Input the provided test scores into column A, starting from cell A2 down to A21.

quartile google sheets

2. Choose a Cell for the Quartile Output

Click on an empty cell where you'd like the quartile result to be displayed. This is where the output from our quartile formula will appear.

google sheets quartile

3. Input the QUARTILE Function with Your Data Range

In the selected cell, type in the quartile formula: =QUARTILE(A1:A20, quart). Here, A2:A21 represents the range of your dataset, and quart is the placeholder for the quartile number you want to calculate.

quartile function google sheets

4. Replace quart in the Formula with the Desired Quartile Number

Decide which quartile you're calculating (1 for Q1, 2 for median/Q2, 3 for Q3, 0 for min, or 4 for max) and replace quart in the formula with that number.

quartile formula google sheets

5. Execute the Formula by Pressing Enter

After entering the correct formula, press Enter. Google Sheets will compute the quartile value and display it in your chosen cell.

google sheets quartile function

6. Modify the Formula for Additional Quartiles as Needed

If you need to find other quartiles, just repeat the steps above, changing the quartile number in the formula accordingly.

quartile in google sheets

We hope that you now have a better understanding of how to use the Quartile function in Google Sheets. If you enjoyed this article, you might also like our article on how to insert the euro symbol in Google Sheets or our article on how to insert page breaks in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->