MAX function

MAX(firstParameter, otherParameters...) MAX(firstParameter; otherParameters...)

firstParameter — Number or { Number }

The first parameter.

otherParameters — Number or { Number } (accepts many)

Additional parameters.

Returns — Number

The largest number of the given numbers.

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

MAX only accepts numbers, or number arrays. Use MAXA instead of you also need to evaluate logical values and text strings representing numbers. Use MAXIFS to only consider values satisfying one or several conditions.

Examples

MAX(4, 22, -4, 32)MAX(4; 22; -4; 32)

Returns 32.

MAX(4, 22, -4, BLANK(), 32)MAX(4; 22; -4; BLANK(); 32)

Returns 32. Blank values are ignored.

MAX({ 4, 22, -4, 32 })MAX({ 4; 22; -4; 32 })

Returns 32. Arrays are supported.

MAX(4, 22, { -4, 32 })MAX(4; 22; { -4; 32 })

Returns 32. Arrays mixed with regular numbers are supported.

MAX(4, 22, { BLANK(), -4, 32 })MAX(4; 22; { BLANK(); -4; 32 })

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