Documentation/Calc Functions/MAX

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MAX

Category:

Statistical Analysis

Summary:

Returns the maximum value in a list of arguments.

Syntax:

MAX(Number1; Number2; ...; Number30)

Returns:

Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.

Arguments:

Number1, Number2, ..., Number30 are numerical values or ranges.

Additional details:

Examples:

=MAX(A1;A2;A3;50;100;200) returns the largest value from the list.

=MAX(A1:B100) returns the largest value from the list.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: