Wauvel

Excel like a finance pro.

← The library

Compatibility function

QUARTILE

Returns a quartile of a data set; still common but QUARTILE.INC is the current name.

CommonDifficulty 1200 · ProficientUsage rank #167 of 520
Practice · 3 questions →

When to use it

Quartiles with the inclusive method. Still common; QUARTILE.INC is the current name.

The shape of it

Syntax
=QUARTILE(array, quart)

Worked examples

  • Q1

    =QUARTILE({1,2,4,7,8,9,10,12},1) → 3.5

    First quartile.

  • Q3

    =QUARTILE({1,2,3,4,5},3) → 4

    Third quartile.

  • Q3 again

    =QUARTILE({1,2,4,7,8,9,10,12},3) → 9.25

    Third quartile of the eight values.

Worth knowing

  • QUARTILE.INC is identical.
  • quart 0 to 4.
  • IQR is Q3 minus Q1.

Where it goes wrong

  • #NUM! for quart outside 0 to 4.
  • Autocomplete steers to QUARTILE.INC.

Related

FORECASTMODEPERCENTILERANKSTDEVNORMDIST

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.