Formulas and functions > Functions from A to Z

Syntax:

MINA(Value1 [, Value2, Value3 ...])

Description:

The MINA function is almost identical to the MIN function (see note). It thus returns the smallest value within the specified values.

Number1, Number2, etc. are the numbers to be evaluated.

Note:

Unlike MIN, MINA also evaluates logical values and text: both FALSE and text are evaluated as 0. TRUE is evaluated as 1.

Empty cells, however, are also ignored here.

Example:

MINA(5, 7, 4, 9) returns 4

If the cells A1:A3 contain 5, 2 and TRUE:

MINA(A1:A3) returns 1 (since TRUE = 1)

MIN(A1:A3) returns 2 (the logical value TRUE is ignored here)

MINA (minimum)