Functions
QUARTILE
Quartile (inclusive)
Try it
When to use it
When should I use QUARTILE?
Use QUARTILE to split a dataset into four equal groups and find the boundary values (Q1, median, Q3) — useful for summarizing salary distributions, test score spreads, or sales performance ranges.
Used in
Syntax
QUARTILE(array,quart)Examples
=QUARTILE({1,3,5,7,9},0) // => 1
=QUARTILE({1,3,5,7,9},1) // => 3
=QUARTILE({1,3,5,7,9},2) // => 5