MIN

returns the smallest value in a set · from excel · excel: verified match · sheets: verified match

signature

MIN(number…)

returns: number

argumentrequired
number… required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

A
1 10
2 20
3 30
4 40
5 50
fx =MIN(A1:A10) 10

related

  • ABS returns absolute value of a number
  • ACOS returns arccosine of a number
  • ACOSH returns inverse hyperbolic cosine
  • ACOT returns the arccotangent of a number
  • ACOTH returns the inverse hyperbolic cotangent
  • ADD adds two numbers — sheets exposes the + operator as a function