MAX function
Summary
Returns the maximum value in a list of arguments
Syntax
MAX(number1, [number2], ...)
The MAX function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the maximum value.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the maximum value.
Example
=MAX(A2:A6)
=MAX(A2:A6, 30)
=MAX(A2:A6, 30)