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) |