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.

• max(3.25, 6.78, 2.50, 1.25, 2.39)

  The formula returns the decimal 6.78.