MIN function

MIN returns the minimum value in a list of arguments.

MIN returns 0 if no numeric value or error is encountered in the cell ranges passed as cell references. Text cells are ignored by MIN(). The function MINA() returns 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN(), for example, MIN("string") results in an error.

Syntax

MIN(number1, number2, ...number30)

Example

=MIN(A1:B100) returns the smallest value in the list.