Stat Β· Nov 16, 2026

The MIN function,
measured & explained.

MIN returns the least number among its arguments. Like MAX it ignores text and blanks in a range and returns 0 when no numbers are present. Use it for the lowest score or cheapest price; MIN(cap, value) clamps a result at an upper bound.

D1
fx
=MIN(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 β€” Anatomy

How MIN works

Returns a number. Text and blanks in ranges are ignored; no numbers gives 0.

=MIN(number1, number2, ...)
number1The first number, reference or range to search.
number2, ...Optional additional numbers or ranges (up to 255).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 β€” Smallest and clamping

MIN reads the range and clamps

Smallest value plus a constant clamp, measured live. Click any row to load it.

Min and clamp, measured

ExpressionResultWhy
=MIN(A2:A6)45Bottom score
=MIN(B2:B6)800Cheapest sale
=MIN(A2:A8)45Blank and text ignored
=MIN(10,20,30)10Direct numbers
=MIN(A2:A4)78First three scores
=MIN(0,A2:A6)0Clamp at 0
=MIN(-5,-10)-10Smaller negative
=MIN(B2:B8)600All sales
⚠ MIN ignores blanks, so a missing entry does not become 0. Fill blanks first if missing should count as zero.
MIN returns 0 when there are no numbers, mirroring MAX. Use MIN(cap,value) for an upper bound and MAX(floor,value) for a lower bound.
// 03 β€” Try it live

Interactive MIN playground

Edit the table or type any formula β€” the engine evaluates instantly. Load a preset to find lows and clamp values.

A1Sample data β€” click any cell to edit, the formula re-evaluates live
Result
β€”
βœ“ readyHyperFormula 3.5
// 04 β€” Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User β€” each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 β€” Cross-platform

Where MIN works

MIN is a core statistical function present in every Excel version and platform.

PlatformSupportNotesGotcha
βœ“ Supported full MIN◐ Partial works with caveatsCompiled from public docs Β· verify against your build
// Go deeper

Master stat

MIN is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Ignores text and blanks
  • Returns 0 on empty, not an error
  • MIN(cap,value) clamps above
  • MINIFS for conditional min
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 β€” FAQ

Frequently asked