MIN (minimum)

<< Click to Display Table of Contents >>

MIN (minimum)

Syntax:

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

Description:

This returns the smallest value within the given numbers.

Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated.

If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.

Example:

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

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

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

MIN(A1:A3, TRUE) returns 1 (the entered value TRUE is evaluated as 1)

MIN(A1:A3, FALSE) returns 0 (the entered value FALSE is evaluated as 0)

See also:

MINA, MAX, SMALL