MIN

Returns the smallest number in a set of values.

Syntax

MIN(number1, [number2], …)

The MIN function syntax has the following arguments:

  • number1, number2, …   1 to 255 numbers for which you want to find the minimum value.

Specifics

  • Arguments can either be numbers, arrays, or cell references that contain numbers.
  • If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
  • If the arguments contain no numbers, MIN returns 0.

Example

Data (A1)  
10  
7  
9  
27  
2  
FormulaDescriptionResult
=MIN(A2:A6)Smallest of the numbers in the range A2:A6.2
=MIN(A2:A6,0)Smallest of the numbers in the range A2:A6 and 0.0