Formualizer Docs
ReferenceFunctionsStatistics Functions

SMALL

Returns the k-th smallest value in a data set.

Summary

SMALL is often used to find low outliers, minimum thresholds, or bottom-N values.

Remarks

  • k must be at least 1.
  • Returns #NUM! if k is greater than the count of numeric values.
  • Non-numeric values in referenced ranges are ignored.

Examples

Second-smallest from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
4
Third-smallest from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
8

FAQ

Does SMALL include text in referenced ranges?

No. Non-numeric range values are ignored when selecting the k-th smallest value.

Runtime metadata

Category

Statistics

Signature

SMALL(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

PUREREDUCTIONNUMERIC_ONLY

Source

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

SLOPE

Returns the slope of the linear regression line for paired data.

STANDARDIZE

STANDARDIZE: Returns the z-score of `x` relative to a mean and standard deviation.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes SMALL include text in referenced ranges?Runtime metadata