MINA

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)