First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
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.
First
The first temporal value or array of temporal values.
Other
Additional temporal values or arrays of temporal values.
Returns
The latest of the given temporal values.
Returns the latest of the given temporal values. MAX (StartDate, EndDate) MAX (StartDate; EndDate) returns whichever of the two dates is the later one.
This overloaded function accepts temporal values, or arrays of temporal values. Use MIN instead to obtain the earliest of a number of temporal values.