MAX

Returns the maximum value in a list of arguments. MAX requires at least one argument. You can use single arguments and/or scope arguments.

Example

=MAX(A1;A4:A6) returns 123.

MAX