Documentation/Calc Functions/MAXA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

MAXA

Category:

Statistical Analysis

Summary:

Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.

Syntax:

MAXA(Value1; Value2; ...; Value30)

Returns:

The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.

Arguments:

Value1; Value2;...; Value30 are values or ranges. Text has the value of 0.

Additional details:

Examples:

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

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

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: