MIN

Returns the smallest of given numbers

Usage

MIN(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

MIN(a, b, c)

a is 10.5
b is -3
c is 4

-3

MIN([2, 6, 3])

(None)

2

MIN(-10)

(None)

-10

MIN(value, 100)

value is 110

100

MIN(value, 100)

value is 40

40

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

(None)

-1

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