MINA

Returns the smallest from the specified arguments, including logical and text values.

Syntax

MINA( Any value1, [Any value2], ... ) → Number

Parameters

value1
value2
…

One or more numbers, texts, or logical values for which to find the minimum value.

Remarks

The arguments can be either numbers, text, or logical values, or cells or arrays, containing numbers, text, or logical values. Text values are treated as zeros. Logical TRUE is treated as 1, and FALSE is treated as 0. Empty cells are not included.

Example

Formula

=MINA(A1:A5)
=MINA(A1:A5,"V",1>0)

See Also

Function Reference
MIN Function
MAX Function
MAXA Function