MAXA function

MAXA(First, Other...) MAXA(First; Other...)

First

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

The first parameter.

Other

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

Additional parameters.

Returns

Number

The largest number of the given parameters.

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

MAXA accepts numbers, logical values and text strings representing numbers. MAX, 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.

MAXA takes the language of the app into account when converting text strings to numbers. When MAXA 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 MAXA 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

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

Returns 32.

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

Returns 32. TRUE is interpreted as 1.

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

Returns 32. Blank values are ignored.

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

Returns 32. Arrays are supported.

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

Returns 32. Arrays mixed with regular numbers are supported.

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

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