<< Click to Display Table of Contents >> MINA (minimum)

Syntax:

MINA(Number1 [, Number2, Number3 ...])

Description:

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

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

Note:

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

Empty cells, however, are also ignored here.

Example:

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

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

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

MIN(A1:A3), on the other hand, results in 2 (because the logical value TRUE is ignored in the MIN function)

See also:

MIN