Investment Studio > Expressions > Functions > Statistical > MAX

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

Returns the largest 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

=max(1, 2, 3)

returns 3.

Assuming standard US date format settings,

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

returns 36892 (the value of the date "1/1/2001", translated to float);

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

returns 1000000;

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

is an error (no valid values).

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