Returns the minimum value in a list of arguments.
MIN(Number1; Number2; ...; Number30)
Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.
Number1, Number2, ..., Number30 are numerical values or ranges.
=MIN(A1:B100) returns the smallest value in the list.