Formualizer Docs
ReferenceFunctionsStatistics Functions

QUARTILE.INC

QUARTILE.INC: Returns an inclusive quartile value for a data set.

Summary

QUARTILE.INC maps quartile index 0..4 onto minimum, quartiles, median, and maximum.

Remarks

  • Valid quartile index values are 0, 1, 2, 3, and 4.
  • Uses inclusive percentile logic for quartiles 1 through 3.
  • Returns #NUM! for invalid quartile index values or empty numeric input.
  • Alias QUARTILE is supported.

Examples

First quartile from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Third quartile from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
32.5

FAQ

Which quartile numbers are valid for QUARTILE.INC?

Only 0 through 4 are valid; other quartile indices return #NUM!.

Runtime metadata

Category

Statistics

Signature

QUARTILE.INC(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

QUARTILE.EXC

QUARTILE.EXC: Returns an exclusive quartile value for a data set.

RANK.AVG

RANK.AVG: Returns the rank position of a number, averaging the rank positions for ties.

On this page

SummaryRemarksExamplesRelated functionsFAQWhich quartile numbers are valid for QUARTILE.INC?Runtime metadata