MIN

Returns the smallest number in a set of values.

Syntax

MIN(number1,number2, ...)

Number1,number2, ...   are 1 to 30 numbers for which you want to find the minimum value.

Examples

If A1:A5 contains the numbers 10, 7, 9, 27, and 2, then:

MIN(A1:A5) equals 2

MIN(A1:A5, 0) equals 0

MIN is similar to MAX. Also see the examples for MAX.