Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Statistical function

QUARTILE.INC

Returns a quartile of a data set (0 = min, 2 = median, 4 = max).

OccasionalDifficulty 1250 · ProficientUsage rank #123 of 520

Practice · 3 questions →

When to use it

The quartiles of a data set with the inclusive method: 0 min, 1 first quartile, 2 median, 3 third quartile, 4 max. The interquartile range is Q3 minus Q1.

The shape of it

Syntax: =QUARTILE.INC(array, quart)

Worked examples

Q1
=QUARTILE.INC({1,2,3,4,5},1) → 2
First quartile.
Q3
=QUARTILE.INC({1,2,3,4,5},3) → 4
Third quartile.
IQR
=QUARTILE.INC(A2:A100,3)-QUARTILE.INC(A2:A100,1) → 18,500
The interquartile range of the salaries.

Worth knowing

Outlier rule: below Q1 - 1.5 × IQR or above Q3 + 1.5 × IQR.
The same as PERCENTILE.INC with k = 0, 0.25, 0.5, 0.75, 1.
Box-and-whisker charts use these numbers.

Where it goes wrong

#NUM! when quart is outside 0 to 4.
Non-integer quart values are truncated.

AVERAGE COUNT COUNTA COUNTIF COUNTIFS MAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.