Formualizer Docs
ReferenceFunctionsDatabase Functions

DMIN

DMIN: Returns the smallest value in a database field for records matching criteria.

Summary

DMIN applies criteria filtering and then evaluates the minimum numeric value from field.

Remarks

  • Criteria rows are ORed together; criteria columns on the same row are ANDed.
  • field resolves from a case-insensitive header label or 1-based index, and invalid resolution yields #VALUE!.
  • If no numeric values are matched, this implementation returns 0.

Examples

Minimum revenue for East or West
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
46000
Minimum units where revenue exceeds 100000
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
22

FAQ

How are mixed criteria (text plus numeric operators) handled in DMIN?

Criteria are parsed per criteria cell, then applied as AND within row and OR across rows before the minimum is chosen.

Runtime metadata

Category

Database

Signature

DMIN(arg1, arg2, ... argN: Any)

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

Arity

min 3, max 1

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/database.rs

DMAX

DMAX: Returns the largest value in a database field for records matching criteria.

DPRODUCT

DPRODUCT: Multiplies values in a database field for records that satisfy criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are mixed criteria (text plus numeric operators) handled in DMIN?Runtime metadata