MAX (Primitive Spread Function) 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. 

EXAMPLES:

MAX(A1,B2,C3,D4,E5)
MAX(A1:A9)
MAX(2,15,12,3,7,19,4)=19