Excel Function: MAX

The Excel function MAX returns the largest number in a series of values.

Usage:

=MAX(range_of_values)

or

=MAX(value_1, value_2, value_3, etc)


Example of use

Select the MAX function and enter into Number1 the range of cells containing the values:

max function png

Click OK.

The maximum is displayed:

max