MAX

Returns the largest value in a set of values.

Syntax

MAX(number1, [number2], ...)

Arguments

• number1, number2, ...: Numbers, cell references, or ranges to evaluate.

Example

MAX(10, 20, 30) → Returns 30
MAX(A1:A10) → Returns the largest value in the range A1:A10