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
Returns 32. Arrays mixed with regular numbers are supported.