MAX

Returns the largest of given numbers

Usage

MAX(numbers...)

Parameters

numbers

(Required) A number or a list of numbers

...

You can use as many numbers and lists of numbers as you want (at least 1). See examples below

Examples

Example With these variables Result

MAX(a, b, c)

a is 10.5
b is -3
c is 4

10.5

MAX([2, 6, 3])

(None)

6

MAX(-10)

(None)

-10

MAX(value, 0)

value is -3

0

MAX(value, 0)

value is 10

10

MAX([2, 6, 3], [-1, 10])

(None)

10

Reminders

A text containing digits is not handled as a number. To have an actual number:

  • use the @NUMBER_QUESTION to set the variable
  • write a numeric value directly in the code without quotes, ex: age >= 18
  • use a function which converts to a number: NUMBER(text_containing_numbers)
  • use a function which returns a number: FIND("world", "hello everybody")

See also