MINA function

MINA(firstParameter, otherParameters...) MINA(firstParameter; otherParameters...)

firstParameter — Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color }

The first parameter.

otherParameters — Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color } (accepts many)

Additional parameters.

Returns — Number

The smallest number of the given parameters.

Returns the smallest number of the given numbers. MINA(4, 22, "-4", 32)MINA(4; 22; "-4"; 32) returns -4.

MINA accepts numbers, logical values and text strings representing numbers. MIN, by contrast, only accepts numbers. TRUE is interpreted as 1, FALSE is interpreted as 0, colors are ignored and text strings are parsed as though TONUMBER is used.

MINA takes the language of the app into account when converting text strings to numbers. When MINA is used with an app whose language is set to German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. When MINA is used with an app whose language is set to UK English, for instance, a decimal point (".") should be used. Thousands separators may not be used.

Examples

MINA(4, 22, "-4", 32)MINA(4; 22; "-4"; 32)

Returns -4.

MINA(4, 22, "-4", 32, TRUE)MINA(4; 22; "-4"; 32; TRUE)

Returns -4. TRUE is interpreted as 1.

MINA(4, 22, "-4", BLANK(), 32)MINA(4; 22; "-4"; BLANK(); 32)

Returns -4. Blank values are ignored.

MINA({ 4, 22, "-4", 32 })MINA({ 4; 22; "-4"; 32 })

Returns -4. Arrays are supported.

MINA(4, 22, { "-4", 32 })MINA(4; 22; { "-4"; 32 })

Returns -4. Arrays mixed with regular numbers are supported.

MINA(4, 22, { BLANK(), "-4", 32 })MINA(4; 22; { BLANK(); "-4"; 32 })

Returns -4. Arrays mixed with regular numbers are supported. Blank values are ignored.