Documentation/Calc Functions/MIN

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

MIN

Category:

Statistical Analysis

Summary:

Returns the minimum value in a list of arguments.

Syntax:

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

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

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: