MAX

Returns the largest value in a set of values.

Syntax

MAX(number1,number2, ...)

Number1,number2, ...   are 1 to 30 numbers for which you want to find the maximum value.

Examples

If A1:A5 contains the numbers 10, 7, 9, 27, and 2, then:

MAX(A1:A5) equals 27

MAX(A1:A5,30) equals 30