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