Documentation/Calc Functions/MIN

Function name:
MIN

Category:
Statistical Analysis

Summary:
Identifies the minimum value in the list of numbers passed as arguments, ignoring empty cells and cells containing text.

Syntax:
MIN(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns the smallest value from the list of numbers passed as arguments, ignoring empty cells and cells containing text.

Arguments:
Number 1, Number 2, …, Number 255 are numbers, references to cells or to cell ranges of numbers. Empty cells and cells containing text are ignored.

The logical value TRUE counts as 1, while FALSE counts as 0


 * The function returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s).
 * Passing a literal string argument to MIN, e.g. MIN("string"), results in an error.

Additional details:
Text cells are ignored by MIN. The function MINA returns 0 if no value (numeric or text) and no error was encountered.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/MAX MAX]

[[Special:MyLanguage/Documentation/Calc_Functions/MAXA MAXA]

[[Special:MyLanguage/Documentation/Calc_Functions/MAXIFS MAXIFS]

[[Special:MyLanguage/Documentation/Calc_Functions/MINA MINA]

[[Special:MyLanguage/Documentation/Calc_Functions/MINIFS MINIFS]

ODF standard:
Section 6.18.48, part 2

Equivalent Excel functions:
MIN