Using the Excel MIN Function

Summary
The Excel MIN function will return the smallest numeric value from a range of values. The function ignores TRUE/FALSE, text values, and empty cells.To find the largest number from a range of values, use the MAX function.
Syntax
=MIN (number1, [number2], ...)Syntax Breakdown
Number 1Required. The number for which you want to find the minimum value. The argument can be a number, name, array, or cell reference.
Logical values, such as TRUE and FALSE, and numbers entered as text are ignored, unless they are entered directly into the list of arguments.
Number 2
Number 2 and subsequent arguments are optional. The function can accept up to 255 arguments.
Usage Notes
MIN returns the smallest value from a set of provided values. The function ignores empty cells, text values, and logical values. The function returns 0 (zero) if the arguments contains no numbers.Arguments with error values or text that cannot be translated into a number will cause an error.
Use the MINA function if you would like to include logical values in a reference.