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