The MAX function returns the maximum (largest) value in the list. The list can include numbers, cell addresses, ranges, and cell names.
For example:
MAX(1, 2, -16, 8)
returns largest number in the list, which is 8.
See also:
Other statistical functions