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