MIN function

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.

Remarks

• You can specify arguments that are numbers, empty, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.

• If an argument is a column reference, only numbers are used. If logical values and text should not be ignored, use MINA instead.

• If the arguments contain no numbers, MIN returns 0.

Examples

Col1	Col2	Col3	Col4	Col5	Formula	Description (Result)
10	7	9	27	2	=MIN([Col1],[Col2],[Col3],[Col4],[Col5])	Smallest of the numbers (2)
10	7	9	27	2	=MIN([Col1],[Col2],[Col3],[Col4],[Col5],0)	Smallest of the numbers and 0 (0)