Article updated on April 18, 2018

The MINA function returns the smallest number.

Text values and blanks are ignored, boolean value TRUE evaluates to 1 and FALSE to 0 (zero).

Error values cause the function to return an error.

Formula in cell B13:

=MINA(B3:B10)

Excel Function Syntax

MINA(value1, [value2], ...)

Arguments

value1 Required. Value or cell ref for which you want to find the smallest number.
[value2] Optional. Up to 254 additional arguments.

Comments

MINA function returns 0 (zero) if argument has no values.

Use the MIN function if you don't want to include logical values in the calculation.