max

Use the max function to identify the highest value of two or more Integer/ Decimal values, or values that make up a Collection.

Function format

max(Input value)

• Input value: accepts Integer/ Decimal values, or a Collection. Value compared against the other value(s) to find the highest value.

max example

max(1, 2, 3, 4, 5)

The formula returns the Integer 5.