In this article:

May 8, 2024

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.

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
- 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.

- 0

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

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

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.

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.

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.

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

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

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

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

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 ->