Formualizer Docs
ReferenceFunctionsStatistics Functions

PERCENTRANK.INC

PERCENTRANK.INC: Returns the inclusive percentile rank of `x` within a numeric data array.

Summary

PERCENTRANK.INC maps values to [0, 1] and interpolates linearly between data points.

Remarks

  • x must be within the observed min/max range; otherwise returns #N/A.
  • Optional significance controls decimal truncation and defaults to 3.
  • significance must be at least 1.
  • Returns #NUM! for invalid setup such as empty numeric input.

Examples

Exact inclusive percentile rank
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5
Interpolated inclusive percentile rank
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.375

Runtime metadata

Category

Statistics

Signature

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

PERCENTRANK.EXC

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

PHI

PHI: Returns the standard normal probability density at `x`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata