MINA


Description Returns the smallest value in the specified list of numbers.

This function is equivalent to the MIN function, but its implementation treats text and logical values in cell and range references differently.

Syntax MINA ( number_list )

Argument Description
number_list A list of between 1 and 30 arguments consisting of numbers, cell references, range references, and/or array constants.Text in cells referenced by this function is treated as the number 0 (this includes zero-length text). Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Text and logical values in arrays are ignored. Logical values referenced in cells or entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Examples This function returns 50:

MINA(50,100,150,"500",200)

This function returns 0:

MINA(TRUE,FALSE)

See Also AVERAGE, AVERAGEA, MAX, MAXA, MIN