Home/Formulas/Math/MIN
Matheasy

MIN()

Returns the smallest numeric value in a dataset.

Syntax
fx
=MIN(value1, [value2, ...])
Arguments
ArgumentDescription
value1The first value or range to consider.
[value2, ...]Additional values or ranges to consider.
Try it
F2
→
9,200
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Empty cells and text cells are skipped. If every cell in the range is empty, MIN returns 0, not an error.
  • Booleans are NOT counted (TRUE/FALSE → ignored). Convert with --A:A if you want to fold them into the comparison.
Related formulas
MAX()
Returns the largest numeric value in a dataset.
Used by
MAX()
Returns the largest numeric value in a dataset.
More Math formulas →Keyboard shortcuts for Sheets →