MAX

Syntax:

MAX(list)

Returns the maximum value in the list.

list may be an array, a range of cells, or a comma-separated list of values.

Example:

MAX(1, 2, 6)

returns the number 6.