MAX
Name
Maximum value
Description
Returns the maximum value of all arguments.
Syntax
MAX(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell or cell range, a float value, or an integer value.
See also MIN.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
MAX(R1C2,5,R3C5,7)
MAX(A1,B2,C3,D4,E5)
MAX(A1:A9)
MAX(2,15,12,3,7,19,4)=19