|
<< Click to Display Table of Contents >> MINA (minimum) |
Syntax:
MINA(Value1 [, Value2, Value3 ...])
Description:
The MINA function is almost identical to the MIN function (see note). It returns the smallest value in the given values.
Number1, Number2, etc. are the numbers to be evaluated.
Note:
Unlike MIN, MINA also evaluates logical values and text: FALSE evaluates as 0. TRUE evaluates as 1. Text evaluates as 0.
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 evaluates as 1)
MIN(A1:A3) returns 2 (the logical value TRUE is ignored)
See also: