Name

max — Returns the largest value in a set of values.

Syntax

max(number1, number2, ...)
                

The MAX function has the following arguments:

number1

The first number in the set of numbers to be scanned for the maximum

number2

The second number in the set of numbers to be scanned for the maximum

...

Additional numbers in the set of numbers to be scanned for the maximum

Description

The max function returns the maximum value in a set of numbers. At least one value must be in the list, otherwise there is no limit to the number of values in the argument list.

The value returned will be an integer if all of the numbers are integers. The value returned will be a number if any of the values in the argument list are numbers.

Examples

Formula

Description

Result

max(1,2,3)

Choose the maximum integer

3

max(6.3, 12.2)Choose the maximum number12.2
max(8.5, 200, 5)Choose the maximum number200.0