FormulaCraft

QUARTILE

QUARTILE returns one of five quartile values from a dataset: minimum (0), Q1 (1), median (2), Q3 (3), or maximum (4). It is widely used in box-plot construction and for understanding the spread of distributions.

Excel
=QUARTILE(B2:B5,1)
Google Sheets
=QUARTILE(B2:B5,1)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Provide the data range and a quart argument 0–4: =QUARTILE(B2:B5,1).
  2. 2Quart 1 returns the first quartile (25th percentile), quart 2 the median, quart 3 the 75th percentile.
  3. 3The result shows the boundary value at that quartile of the distribution.

Need a version for your data?

Try: “Find the first and third quartile of employee salaries to understand the pay spread”

Related

COUNTACOUNTBLANKMODE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: