Returns the smallest value in the list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers.
Syntax
MINA(value1,value2,...)
Value1, value2,... are 1 to 30 values for which you want to find the smallest value.
Remarks
- You can specify arguments that are numbers, empty , logical values, or text representations of numbers. Arguments that are error values cause errors. If the calculation must not include text or logical values, use the MIN function instead.
- Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
- If the arguments contain no values, MINA returns 0.
Example
| Col1 | Col2 | Col3 | Col4 | Col5 | Formula | Description (Result) |
|---|---|---|---|---|---|---|
| FALSE | 0.2 | 0.5 | 0.4 | 0.8 | =MINA([Col1],[Col2],[Col3],[Col4],[Col5]) | Smallest of the numbers. FALSE evaluates to 0 (0) |