MAX function in Excel

Returns the largest value in a set of values.

Syntax

MAX(number1, [number2], …)

The MAX function syntax has the following arguments:

Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the maximum value.