Documentation/Calc Functions/MINA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

MINA

Category:

Statistical Analysis

Summary:

Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.

Syntax:

MINA(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:

=MINA(1;"Text";20) returns 0.

=MINA(A1:B100) returns the smallest value in the list.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: