Investment Studio > Expressions > Functions > Statistical > MIN

float min(float data [, ...])

Returns the smallest number in the data list.

All elements in the argument list are converted to floats, with exclusion if conversion fails. The list may contain array arguments, in which case each array element is treated as a separate list element.

Examples

=min(-1, -2, -3)

returns -3.

Assuming standard US date format settings,

=min(1, "1/1/2001", "Hello, world!")

returns 1;

=min(1, "1/1/2001", "Hello, world!", "-1E6")

returns -1000000;

=max("Hello", "world!")

is an error (no valid values).

See also average, count, median, max, mode, quartile, trimmean.