# How to Use QUARTILE.EXC function in Google Sheets in 2020?

QUARTILE.EXC functionThe QUARTILE.EXC function returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.

Parts of a QUARTILE.EXC function

QUARTILE.EXC(data, quartile_number)

Part
Description

data
The array or range containing the dataset to consider.

quartile_number
This is which quartile value to return

1 returns the value in data closest to the first quartile (25% mark)
2 returns the value in data closest to the median (50% mark)
3 returns the value in data closest to the third quartile (75% mark)

Sample formulas

QUARTILE.EXC(A2:A100, 3)

QUARTILE.EXC(A2:A100, B2)

Notes

If the quartile_number is not an integer, the number is truncated.
The quartile_number must be between 0 and 4, exclusive.
Different from QUARTILE.INC, QUARTILE.EXC calculates quartile based on a quartile range exclusive of 0th and 4th quartile.

Examples

A

1
data

2
6

3
7

4
15

5
36

6
39

7
40

8
41

9
42

10
43

11
47

12
49

A
B
C

1
Quartile
Result
Formula

2
1
15
=QUARTILE.EXC(A2:A12, 1)

3
2
40
=QUARTILE.EXC(A2:A12, 2)

4
3
43
=QUARTILE.EXC(A2:A12, 3)

Related functions

PERCENTILE: Returns the value at a given percentile of a dataset.
PERCENTILE.EXC: The PERCENTILE.EXC function returns the value at a given percentile of a dataset, exclusive of 0 and 1.
MEDIAN: Returns the median value in a numeric dataset.
QUARTILE: Returns a value nearest to a specified quartile of a dataset.

Categories Uncategorized