Syntax

MIN(some-list)

Arguments

  • some-list (list of any numeric type)

AppSheet must be given enough context to determine what type of values some-list contains, that its contents are or will be numeric. To that end, some-list must be one of the following: a column value of type List that contains numeric values; a column list (e.g., Products[Price]) for a column of a numeric type; or a constructed list (e.g., with LIST()) of a numeric type. See Examples below.

Return Value

The lowest value in some-list.

Examples

MIN(Products[Price]) : The lowest of all values in the Price column of the Products table. Equivalent to MIN(SELECT(Products[Price], TRUE)). See also SELECT().

MIN([Discounts]) : The lowest of the items in the Discounts column value, where Discounts is of type List.

MIN(LIST(1, 2, 3)) returns Number: 1

MIN(LIST(0) - LIST(0)) (a valid constructed list with a type but no items) returns Number: 0 (a valid constructed list with a type but no items)

Potential Problems

MIN(1, 2, 3) : the arguments are not in list form. To fix, wrap them in LIST() to construct a list: MIN(LIST(1, 2, 3)).

MIN(LIST()) : the constructed list has no items from which to determine type.

See Also

AVERAGE(), COUNT(), MAX(), STDEVP(), SUM()

Did this answer your question?