Formualizer Docs
ReferenceFunctionsStatistics Functions

PERCENTILE.INC

PERCENTILE.INC: Returns the k-th percentile of a data set using inclusive interpolation.

Summary

PERCENTILE.INC accepts percentile values from 0 through 1 and interpolates between sorted values as needed.

Remarks

  • k must be in the inclusive range [0, 1].
  • Returns #NUM! for empty numeric input or invalid percentile arguments.
  • Alias PERCENTILE is supported.

Examples

Inclusive 25th percentile from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Inclusive median-style interpolation from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
25

FAQ

What k range is valid for PERCENTILE.INC?

k must be between 0 and 1 inclusive; outside that range returns #NUM!.

Runtime metadata

Category

Statistics

Signature

PERCENTILE.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

PERCENTILE.EXC

PERCENTILE.EXC: Returns the k-th percentile of a data set using exclusive interpolation.

PERCENTRANK.EXC

PERCENTRANK.EXC: Returns the exclusive percentile rank of `x` within a numeric data array.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat k range is valid for PERCENTILE.INC?Runtime metadata