MAX

Syntax:

MAX( list )

Returns the maximum value in the list.

list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).

Example:

MAX(1, 2, 6)

returns the number 6.

Revisions:

Starting with 2.00, this function will accept date / time values.