MIN

The function MIN returns the smallest Number from within a List of Numbers, or from some number of individual Number values.

This function takes input in two forms: it will accept either a List of Numbers, or an arbitrary number of individual Number values. It will return a single Number: the smallest of the Numbers given (either within the list or individually).

Declaration

MIN(list_of_numbers) -> min_of_numbers
MIN(number_1, number_2, ... number_n) -> min_of_numbers

Parameters

list_of_numbers (type: List of Numbers)

A list of Numbers. There is no limit to the number of items that can be in this list.

number_n (type: Number)

The nth individual Number given as input. n can be arbitrarily large; there is no upper limit to the number of Numbers MIN will accept.

Return Values

min_of_numbers (type: Number)

The smallest of the given numbers.

Examples

The following example takes the individual numbers 1, 2, and 3 as input and returns the smallest of the three:

MIN(1, 2, 3) -> 1

The following example takes the List of Numbers [1, 2, 3] and returns the smallest Number of the three in the list. Note that the output is identical to the example above.

MIN([1, 2, 3]) -> 1

While the MIN function accepts input in the form of either a List of Numbers or some individual Number values, it cannot parse a combination of the two. The following example demonstrates how the MIN function will behave if given both a List and an individual Number – namely, that it returns NULL:

MIN([1, 2], 3) -> NULL

Last updated