MAX

Returns the maximum value in a numeric dataset.

Syntax

MAX(value, [value, ...])

• value - The value or range to consider when calculating the maximum value.

Sample Usage

MAX(A2:A6)
MAX(A2:A6, 123, 45)

Return Value

• The maximum value in a numeric dataset.

Notes

See Also